General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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!
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only