many to many then one to many

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

Guest

My report originally pulled from a many to many query and included Employees
Names and Applications listed by Locations. (The many to many is required for
other reports.)
tblEmployees tblJoinEmpWithAPPs tblApplications

My manager wants the report to list ALL employees by Location whether or not
the employee has assigned applications. If, however, applications exist, he
wants the applications listed in the report as well. I can't bypass the JOIN
table because I'll loose the applications. However, using the JOIN table
prohibits me from listing the employees without an application.

Suggestions????

ATLANTA
Sally Diaz Application 1
Application 2
Joe Smith (No Assigned Apps)
Jane Boss Application 1
Application 3
Application 16
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Use a Left Join

FROM (tblEmployees As E LEFT JOIN tblJoinEmpWithApps As J
ON E.EmployeeID = J.EmployeeID)
INNER JOIN tblApplications As A
ON J.ApplicationID = A.ApplicationID
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQm6w+IechKqOuFEgEQLmcgCgyTDoa5qKnKGt+5dA9FAUlmkHJq8AoI8G
KqiwHTXNxUet7aHoJPKGWSCO
=Dduc
-----END PGP SIGNATURE-----
 
Back
Top