I have two tables, table 1 contains 3000 staff records and table 2 contains 300 staff id's.
I need to configure my query so that when it runs the staff records are returned not including the 300 staff id's in table 2.
I thought this would be as straight forward as pointing the criteria to the staff if column in table 2 and using the <> operators. I've tried this but it does not work.
A point in the right direction would be appreciated.
I need to configure my query so that when it runs the staff records are returned not including the 300 staff id's in table 2.
I thought this would be as straight forward as pointing the criteria to the staff if column in table 2 and using the <> operators. I've tried this but it does not work.
A point in the right direction would be appreciated.
