Subject Re: Duplictes query
Author Syarzhuk Kazachenka
>I have a straightforward name & address table,
>each record has a unique ID (primary key)

>I need to identify the ID of those records
>that are duplicated across the name and address
>fields, possibly with some degree of mismatch (ie a %LIKE% element)

Dunno what you do about "some degree of mismatch", but straight duplicates
are found by running the following query:
SELECT T.Name, T.Address, Count(T.ID)
FROM TableName T
GROUP BY T.Name, T.Address
HAVING Count(T.ID) > 1

Get your FREE download of MSN Explorer at