How do I query to find out what data in table 1 column 1 is not i.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does anyone know how I can get a query to display information that is in one
table, but not another? For example: Table 1 Table 2
1 1
2 3
3 5
4
5
What numbers in table 1 are not in Table 2.
I thought it would be a simple Not expression in the query, but I have tried
everything I know of and have failed to produce a working query.
 
Back
Top