How do I set Reverse Joins in Access 2007?

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.
 
A

Allen Browne

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.
 
K

KARL DEWEY

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.
 

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

Trying to create a report that will list unmatched records by Ticket Primary Key 0
A bug in GUI of creating query with more outer joins between two tables 5
Individuals who have not taken course 4
How do I set focus (and select text) on a text box on a modeless userform? 0
Problem with Joining Two Tables 3
Nested JOIN clauses - order of precedence (Access 2007) 2
Dragging Joins in Access 2007 QBE Grid 1
Join on a UNION query 2

Top