From billing a
Where (
(select count(*)
from billing b
where a.first_name = b.first_name
AND a.last_name = b.last_name
)
>1)
-----Original Message-----
From: Jeff Waris [mailto:[EMAIL PROTECTED]
Sent: Friday, April 16, 2004 3:35 PM
To: CF-Talk
Subject: OT: SQL question. Someone help!!!
I am having a hard time finding the right syntax in SQL. Backend
Database is SQL Server 7
What I am trying to acomplish. I have some duplicate records that I need
to get rid of, the problem is that all these records already have a
unique key, but the rest of the fields are the same. I was hoping to be
able to join two fieldnames together and look for the duplicates that
way..
For example... this is where I was headed...
Select from billing.first_name+ billing.last_name AS combined HAVING
COUNT( * ) > 1
It wouldn't work.... Any help would greatly be appreciated.
Jeff
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
