An addittion to Mark Sinkinson's excellent comment:
NOT IN requires you compare a single column from one table with a single column from another table or subquery.
You can, actually, perform NOT IN with more than one column.
E.g. this is a prefectly legal* SQL query:
SELECT E.first_name, E.last_name
FROM employees E
WHERE (E.first_name, E....