Filter a query based off another query

[ddecker3]

Is it possible to set the critiera for a query based off another query?

I have 2 tables: employee and quals

I know how to pull from both tables to say which employee are qualed.
But how do I pull all employees that are not qualed.

Basically if they are on both lists how do I not pull them up.
I know its confusing.

 

[Remou]

Do you mean:

[tt]SELECT Employees.EmpID
FROM Employees
LEFT JOIN Quals
ON Employees.EmpID = Quals.EmpID
WHERE Quals.QualID Is Null[/tt]