query with a join and no values

N

Nathan

I have a ITEM table and a table with a list of my employees.
I want to run a query where I can see ALL the items, and if any employees
are assigned to that item, then the employees names also.

I tried to just run a query with a join, but all I got back was ONLY the
items that had an employee associated with them. But I want to the the items
WITHOUT an employee assigned also. How can I do this?
 
T

tina

you're using an INNER JOIN on your item table and employee table, as

FROM ItemTableName INNER JOIN EmployeeTableName

change the INNER JOIN to a LEFT JOIN, as in

FROM ItemTableName LEFT JOIN EmployeeTableName

the table that contains the records you want to see "all" of, should be
named first in the statement.

hth
 
Top