create a query using two tables

[Godders199]

Hello, I am trying to teach myself Access with the help of Google, but cant find what i am looking for, might just be searching incorrectly.

I want to create a query , based on two tables, the first is Staff, the second is sales the common factor on both tables is their employee number.

The query , I want , is a list of sales for all employees who are not currently off Sick

So I need the citeria to look at the Staff table for employees with the status of sick, and remove these employee numbers from the sales data.

If anyone has examples of these types of queries it would much be appreciated.

 

[Kyle123]

Something like:

SELECT * FROM sales_data inner join staff_data on sales_data.EmployeeId = staff_data.EmployeeId WHERE staff_data.Status != 'Sick'

 

[Micron]

methinks Access sql will not accept != for <> (does not equal) if that's what != means.