outer join

  • Thread starter Thread starter Kevin
  • Start date Start date
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
 
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.
 
Back
Top