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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

A bug in GUI of creating query with more outer joins between two tables 5
Problem with Joining Two Tables 3
How does one report a bug in Access 2007 SQL? 4
Partial match Join query 3
Nested JOIN clauses - order of precedence (Access 2007) 2
Row fix-up/updatable join on linked tables broken in Access 2007? 2
Individuals who have not taken course 3
Join on a UNION query 2

Back
Top