evlai
03-02-2006, 08:45 PM
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.
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.