How to get the names that have mistakes from 2 tables [message #196850] |
Sun, 08 October 2006 10:03  |
drhell
Messages: 1 Registered: October 2006
|
Junior Member |
|
|
Ok here is the thing, i have two tables table1 and table2, they are supposed to contain the same information, but we have found mistakes, the tables contain peoples names and lastnames, how can i get the names that are not typed similar in the 2 tables.
Example: table1 table2
John Jonh
Amanda Amanad
Alex Alxe
I would like to make a query that gets me all the mistakes like the ones shown above. In other words a comparison of the information from the tables, since they have to be exactly the same.
Heres the tables info.
table1/table2 (id,name, last_name, adress, telephone, email, position)
i hope u understand my problem, thanks alot for the help....
|
|
|
|
|