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