>id1 id2 >1 2 >2 1>All I really want in this instance is one entry.
>SELECT Addresses.iid, Addresses_a.iid; > FROM duplicates!addresses, duplicates!addresses Addresses_a; > WHERE Addresses.iid <> Addresses_a.iid; > AND Addresses.csurname == Addresses_a.csurname; > AND Addresses.cforename == Addresses_a.cforename; > AND (Addresses.caddress_1 == Addresses_a.caddress_1; > OR (Addresses.cpostcode == Addresses_a.cpostcode)); > ORDER BY Addresses.csurname, Addresses.cforename >>Many thanks in anticipation.