Need a query help

[evlai]

Supposed I have 2 tables and these 2 tables share the same fields. I would need to compare both tables and see which record is not included in other table.


Table Name: Order_1
Order Number Country
12345 USA
23456 UK

Table Name: Order_2
Order Number Country
12345 USA
23456 UK
312321 Thailand

I need a query to tell me the Order Number of ?312321 Thailand? is not matching/ included in the other table.

[Norie]

Why not use the Find Unmatched Query Wizard?

By the way why do you have 2 tables with the same data structure?

[evlai]

Thanks, i had actually found out the solution.
I need to use 2 tables with same data structure is that i need to compare the data from 2 different sources

Many thanks though.