sql query based on results of another query
Posted on 2013-01-30
I have a query which is identifying a match between 2 tables.
lets say its employees and documents. The scenario is, every employee CAN have a document but it is not neccessary for them to have one.
I have a query which picks out all of the employees who have received a document, this was easy... but we need to know the opposite... ie which employees have not received the document..
how do I structure my second query (assuming I need one) so that it says
show me all employees not in the results of the other query?