outer join

K

Kevin

How can I make outer join?
Access allow to have either left of right outer join.
I need all the data from both table.
Which mean either records are in left or right, I want to select.

Thanks.
-Jay
 
V

Van T. Dinh

Use a UNION Query where one side of the union is the Left Outer Join SQL and
the other side is the Right Outer Join SQL.

Check Access Help on Union Query.
 

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

outer join 10
Access outer joins? 4
Outer Join and a two step query 1
To give inner join and Left outer Join 3
Left outer join 10
Can't outer join or append. 2
Outer Join 1
Relationship - Outer Join - Microsoft Access 2002 1

Top