I have a task to find people who have not competed training.
I have a list of all people by ssn (qry1)and I have a list of all people who have completed training (qry2) What is the best way to get a list of peope who have NOT completed training? It would be in effect qry1 - qry2
Would this be an outer join? How do I set that up?
SELECT qry1.ssn, qry2.training_complete
FROM qry1 LEFT JOIN qry2 ON qry1.ssn = qry2.ssn
WHERE qry2.ssn IS NULL
*Side Note: Many people frown on using ssn as a primary key do to privacy concerns as well as flexibility. In general, having a primary key representing "meaningful data" could put you in an uncomfortable position. For instance, what happens if an employee gets married and changes their name, but you want to preserve the name they had on all activity prior to getting married. How can you add them again if you're referencing ssn instead of an arbitrary key?