nathangoldhill
Registered User.
- Local time
- Today, 21:57
- Joined
- Aug 6, 2001
- Messages
- 12
What is the best way to compare two tables to find differences between the data.
Comparing two tables to find differnces in data
- Thread starter nathangoldhill
- Start date
- Local time
- Today, 16:57
- Joined
- Feb 19, 2002
- Messages
- 47,594
Please don't post the same question under multiple topics.
The find unmatched query wizard will only display differences in the entire record (i.e. if a record exists in one table but not in the other). How would you do something similar but based on the actual fields. For example...
table 1, field 1, value = 'This is my field value'
table 2, field 1, value='This is not my field value'
Note: both tables have identical field structures.
How would I find these differences between the two tables?
The situation is this: I gave a copy of a database to someone who went and made changes/additions to the data (not the structure). While this person was making changes to the copy of the database, changes/additions (not the structure) were being made to the original database. How do I reconsile (or kind the differences) between the tables of the original and the copy of the database?
table 1, field 1, value = 'This is my field value'
table 2, field 1, value='This is not my field value'
Note: both tables have identical field structures.
How would I find these differences between the two tables?
The situation is this: I gave a copy of a database to someone who went and made changes/additions to the data (not the structure). While this person was making changes to the copy of the database, changes/additions (not the structure) were being made to the original database. How do I reconsile (or kind the differences) between the tables of the original and the copy of the database?
