I have 2 tables I am comparing. Each table should have the same records in them, however, because of keying errors in one or the other tables a certain field may have a different number. I want to find those unique instances where the number is different or the record is not in one table or the other. I have tried to delete duplicates but I get the results from one of the tables because the duplicate record has been deleted. How do I find those unique records in each table?
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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Finding Unique Records in 2 Tables
- Thread starter kshadden
- Start date
LonnieJohnson
Programmer
Have you tried running an "unmatched" query?
ProDev, Builders of Affordable Software Applications
Visit me at ==>
May God bless you beyond your imagination!!!
ProDev, Builders of Affordable Software Applications
Visit me at ==>
May God bless you beyond your imagination!!!
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Question