Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Comparing 2 differnet DB tables for Typo's

Status
Not open for further replies.

phospher

Technical User
Mar 19, 2004
9
US
Hi,

I am trying to find a way to compare two DB tables for typos. I exported a customer table, edited a few fields, ie spelling of name or city, SSN etc. Then used the unmatched records query between the tables and nothing came up.

I would appreciate any suggestions.

Thanks,

Phospher
 
Something like this ?
SELECT N.*, O.* FROM newTable N INNER JOIN oldTable O
ON N.PrimaryKey = O.PrimaryKey
WHERE N.Field1<>O.Field1 Or N.Field2<>O.Field2
... Or N.FieldX<>O.FieldX

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top