SQL problem

[kuipers78]

Hello,

I've got two tables with the following field values:

Table1, Field 'Planned Groups'
2
4
6
4
7

Table2, Field 'Total Groups'
1
2
3
4
5
6
7
8
9
10

Now I want my query to display the groups that aren't planned. So, the result of comparing the fields of both tables should be 1, 3, 5, 8, 9, 10.
I know this is possible with a query, but I can't figure out the correct SQL. Anybody who can help me, please???

 

[DCrake]

Use the unmatched query wizard to step you through the actions and examine the query afterwards.

 

[kuipers78]

Thank you very much, it worked!