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

Can't outer join or append. 2
Outer Join and a two step query 1
Relationship - Outer Join - Microsoft Access 2002 1
To give inner join and Left outer Join 3
A bug in GUI of creating query with more outer joins between two tables 5
outer joint query 1
Left outer join 10
Outer Join 1

Top