Can someone help me with the SQL to find duplicate records in a table where a duplicate is considered two out of five matching fields? I thought:
SELECT * ;
FROM table;
WHERE keyfield IN ;
(SELECT keyfield ;
FROM tablel ;
GROUP BY keyfield, field2;
HAVING count(*) > 1)
would do the trick, but it doesn't work. TIA
Erik
Erik Moore
Clientelligence