Exceptions Queries

[robbydogg]

Hello All,
I know i'm being dim , but my brain has hit a thought-trench.
I have two table and need to compare data between the two and report the exceptions.
Both TBL1 and TBL2 has two columns (C1 and C2) i need to reference against each other.
I need to extract the following:
Where C1 and C2 completely match between TBL1 and TBL2
Where C1 is incorrect on the TBL1 compared to TBL2
Where C2 is incorrect on the TBL1 compared to TBL2
Where neither C1 or C2 match from TBL1 compared to TBL2.

I know it should be simple but i'm a bit stuck and your help would be greatly appreciated.

 

[maxmangion]

try using the unmatched and find duplicates query types ?

 

[robbydogg]

that's a very good point, thanks for removing the dimness from my brain.

 

[maxmangion]

you're welcome