>>>I have a table that includes these three fields: soc_sec_num, activate_code, and ded_code. I need to find only the duplicate records where the soc_sec_num, activate_code, and ded_code are the same.
>>>
>>>Can anbody help with the SQL to do this?
>>>
>>>Thanks!
>>>
>>>Jeff
>>
>>Select * From yourtable Group By soc_sec_num, activate_code, ded_code Having Count(*)>1
>
>
>great !!!
It is the most common question someone can meet going to interview for Foxpro position.
Edward Pikman
Independent Consultant