I have a table of People and a related table of their physicals. I need to do a query to find everyone who does not have a record in the Physical Table. The following SQL shows me everyone who does have a physical, so basically I need everyone who isn't in this query.
SELECT Person.FullName, Physical.PhysicalDate
FROM Person INNER JOIN
Physical ON Person.PersonKey = Physical.PhysicalParentKey