Compare data in different tables and list non matching values

[Avipatel]

Hi

I am trying to compare data in two different tables and list the data that does not match. Not sure if this is possible. Details below

Table 1

xyz - A1 - Do not use
ABC - A4 - Use

Table 2

123 - A1

The result of the query should show me

A4 (as this does not appear in table 2

I am not too familiar with Null values as there will be many null values that i want to ignore.

Any help will be appreciated.

 

[Brianwarnock]

Use the unmatched query wizard.

Brian

 

[RuralGuy]

See if the Find Unmatched Query Wizard can get you started.

 

[Avipatel]

Thanks

That works and gives me the correct result. I should have been more aware cause that was staring me in the face.

 

[Brianwarnock]

Don't worry, it's not unusual to miss what's staring you in the face.

Brian