How do I set Reverse Joins in Access 2007?

  • Thread starter Thread starter BJ
  • Start date Start date
B

BJ

During training we were told about Reverse Joins. I don't find this in Access
2007. Anyone know if it was taken out?

I am trying to run a report with all names from one table even if the names
are not in the second table, and vice versa.
 
JET supports INNER, LEFT, and RIGHT JOINs.

Use the 'Unmatched Query Wizard' (first dialog when you create a new query)
to generate this query for you.
 
I would use a union query to build complete list. Then use it in a left join
from union to first table left join to second table.
Use union query as output field for the name.
 
Back
Top