Essential Books

Filter query results using query on different table

suggest change

This query selects all employees not on the Supervisors table. 

SELECT *
FROM Employees
WHERE EmployeeID not in (SELECT EmployeeID
                            FROM Supervisors)

The same results can be achieved using a LEFT JOIN. 

SELECT *
FROM Employees AS e
LEFT JOIN Supervisors AS s ON s.EmployeeID=e.EmployeeID
WHERE s.EmployeeID is NULL
Found a mistake? Have a question or improvement idea? Let me know.

Feedback about page:

Feedback:
Optional: your email if you want me to get back to you:

Subqueries:
*Subqueries
*Subquery in FROM clause
*Subquery in WHERE clause
*Subquery in SELECT clause
*Correlated Subqueries
*Subqueries in FROM clause
*Filter query results using query on different table
*Subqueries in WHERE clause
*Subqueries in SELECT clause
Table Of Contents