>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
Need more info. Can field1 in one record be = field2...5 in another record?