EzGoingKev
Registered User.
- Local time
- Yesterday, 21:36
- Joined
- Nov 8, 2019
- Messages
- 178
I have two data sets - a master table and an application table.
Both tables have multiple fields that differ but have six fields that are supposed to match each exactly.
I wrote two queries:
Both queries are joined using the EXACT same fields.
When I do the master vs the application table there is nothing shows up as non-matching.
When I do the application vs the master table I get one return. I have visually reviewed all the data in both tables and it matches 100%.
I cannot determine why it does not match. The thing that really confuses me is why it matches up in one query while the same exact data does not match up in another query.
Anyone know what is going on?
Both tables have multiple fields that differ but have six fields that are supposed to match each exactly.
I wrote two queries:
- master vs application tables -> checks to see if there is anything in the master that is not in the application table
- application vs master tables -> checks to see if there is anything in the application table that is not in the master table
Both queries are joined using the EXACT same fields.
When I do the master vs the application table there is nothing shows up as non-matching.
When I do the application vs the master table I get one return. I have visually reviewed all the data in both tables and it matches 100%.
I cannot determine why it does not match. The thing that really confuses me is why it matches up in one query while the same exact data does not match up in another query.
Anyone know what is going on?
Last edited: