duplicates in all fields

M

macroapa

Hi,

How do a write a query that will identify duplicate records in a table
where all fields in the record are identical (and delete the dups so
just one remains).

I need to merge 2 tables that may contain duplicate records.

Thanks.
 
Top