query with a join and no values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
Back
Top