HAVING is the key. I've "been" to the Anders Altberg SQL school.
>Much better. I didn't want to throw in the "having" because I was away from VFP.
>
>>
>>SELECT COUNT(Sin) as DupCnt, Sin + DTOS(Add_date) + Add_time AS pKey ;
>> FROM SheenaTable ;
>> GROUP BY pKey;
>> INTO CURSOR cDuplicates ;
>> HAVING DupCnt > 1
>>
>>
>>
>>
>>>>Hi:
>>>>
>>>>I want to list duplicate records that are violating my primary key of sin+dtos(add_date) + add_time form my employ table.
>>>
>>>Off the top of my head
>>>
>>>SELECT cnt(sin) as dupcnt, sin+dtos(add_date) + add_time as pkey ;
>>> FROM sheenatable ;
>>> ORDER BY 1 DESC ;
>>> GROUP by 2 ;
>>> INTO CURSOR cDuplicates
>>>
>>>
>>>Then look for any items with dupcnt > 1