Unmatched records Urgen help req . Thanks

[Neerja]

Hello all, I have 2 tables.
I wish to fetch all the records which are not common in two tables.

I do not have Exp with the Unmatched query wizard. I want to sleect the records based on more than one criteria and wizards allows to select on only one field.

Any suggestions please.

Thanks!!

 

[namliam]

Just add the columns you wish to examine to your query and add "<> [OtherTable].[SameColumn]" to the criteria
Add that for each of the columns and you have your unmatched