queries to make exclusions

[shanedavid1981]

hi,

I'm looking to write a query that will exclude records from a main workforce table that are listed in a supervisor table, so that managers/supervisors wouldnt be listed from the workforce table in my mainstream reports...

is there an easy way to do this?

thanks!

 

[Golom]

Just taking wild guesses at the fields in your tables

Select EmployeeID From tblWorkForce

Where  EmployeeID NOT IN 
       (Select EmployeeID From tblSupervisors)

 

[shanedavid1981]

thanks )

i also remembered i could cheat by modifying an unmatched query between the supervisor and workfoce listings, hehe!