1

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....


Only top voted, non community-wiki answers of a minimum length are eligible