I am looking for a little more help on queries. I have 3 tables (ContactInfo, Current Employees, Pot Employees)
in the potential employee table, it references the contactID as a foreign key. I want to be able to only see a list of individuals if they are not current employees. In other words, if there is an entry in the employeeID field (referenced from the contactinfo table) then I do not want them in my potential employee query.
I only want to see a list of people NOT in the employee table.