SQL "NOT IN" with different tables

[DPF]

Dear accessforums.net user,



i have a big Problem and do not find it!

How do I make a query with "not in" over several tables?

Example:

SELECT number
FROM customer
WHERE number NOT IN (SELECT number FROM employee);

this emaple doesn´t work! AND there is a error message.

[aytee111]

Here is some good information on subqueries: http://allenbrowne.com/subquery-01.html