>>Hi Gang!
>>
>>I want to be able to find records in a table that have more than one field that is duplicate (last_name + first_name). We want to get rid of the duplicate fields (combine them together).
>>
>>So first, to find them....
>>
>>Is this code ok? To find all duplicate records on last_name + first_name ?
>>
>>

>>SELECT last_name, first_name, alt_custno, paquinnumb FROM customer ;
>>	WHERE last_name + " " + first_name IN ;
>>		(SELECT last_name + " " + first_name AS cust_name FROM customer ;
>>			GROUP BY last_name, first_name ;
>>			HAVING count(last_name + " " + first_name) > 1);
>>	ORDER BY last_name, first_name INTO CURSOR FINDDUPE
>>
>>

>>
>>Runs ok, but I want to be sure from others!
>>
>>Thanks!
>
>The code is OK. You can also use a variation of it:
>

>SELECT last_name, first_name, alt_custno, paquinnumb FROM customer ;
>	inner join (select LastName, FirstName, count(*) as Dups from Customer group by LastName, FirstName having count(*) > 1) X
>on Customer.LastName = X.LastName and Customer.FirstName = X.FirstName

I Like !!!

Thanks!!!