|Subject||Re: [IBDI] Duplictes query|
> I have a straightforward name & address table,Do a select-statement which joins the same tables for records having the same
> 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)
SELECT N1.NameID, N2.NameID
FROM Name N1, Name N2
WHERE N1.NameID < N2.NameID and (xxxx)
xxxx are your rules for duplicate records like N1.Prename = N2.Prename or
N1.NameID < N2.NameID is for not getting the two similar records returned
The disadvantage of this statement is, that when you have three times the
same records you will get returned two rows.
Please notice, that this is not a support group! Go on with further support
question at ib-support in groups.yahoo.com.