>>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!!!

You're welcome. You may compare output of sys(3054,11) in both cases to find more performant variation.