>Hello Erik,
>The real table has 70 fields. Do I have to specify the 69 fields in the GROUP BY clause?
>
>>>I have a table with 5 fields and I'd like to get rid of the dup records base of 4 fields. The SELECT DISTINCT command doesn't work in this case because it compares the whole record.
>>>
>>>Any sugestions? Thank you in advance.
>>
>>you can choose your criteria for your uniqueness check with the GROUP BY clause:
>>
>>SELECT COUNT(*), * FROM Mytable GROUP BY Field1, Field2, Field3, Field4 HAVING COUNT(*) > 1
The group by clause contains only the fields you want to use to determine uniqueness. If you are basiing your definition of uniquness on the contents of 4 fields, put those for fields in the GROUP BY clause.
Erik Moore
Clientelligence