If I had a primary field my life would be so much easier! To find duplicate records, I need to compare the dob,last_name, and first_name.

This is why I was going to use 2 tables i.e. select * from table1,table2 where table1.dob = table2.dob and table1.lastname= table2.lastname and table1.firstname = table2.firstname.

Sunshine

P.S. Thanks for your response!