Please Help: compare values in two columns present in seperate tab

[sam]

Hi All,


How can I compare values in two columns (columns are in different tables) ?
I also want to display the values that dont match in a seperate table.

For eg:

If values in Column1 from Table1 does not match Values in Column1 from
Table2 then display those values in a seperate table

Is there a way to do this?

THanks in advance

 

[golfinray]

Under query types, there is one for unmatched data and one for matched.