Query table and only return results NOT in another table in ACCESS
I have 2 tables Humres with a field em_id and another table (dbo_emptrain) that has a field empID. The Humres table has ALL employees listed in it, the emptrain table has only employees that we have assigned something in this database. I want to run a query that shows me only employees that haven't been assigned to the emptrain table.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER