• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2008
  • Last Modified:

Outer join function in Access

Dear All,
     Do anyone know how to get all the results in 2 tables A and B?
A and B has  a relationship of ID in each table, but I want to get all the result in A and B and also the result of A.id = B.id. How can I do that?
It seems likely to be the function of outer join in MsSQL, isn't it?
However, Access doesn't have this function, am I right?
0
foward
Asked:
foward
  • 2
1 Solution
 
jobrienctCommented:
select * FROM A, B;  ?

im not sure you are asking the right question.

why dont you start by describing your current table structure and the question you would like answered by your query?

John
0
 
jobrienctCommented:
or just in case you know what you want: select * from a,b where a.id = b.id;

John
0
 
BillPowellCommented:
Access doesnt have outer joins but you can simulate it by doing creating three queries:

1.  Select query changing join type to select all records in A and only related records in B
2.  Select query changing join type to select all records in B and only related records in A
3.  Union query to combine the previous two queries

This provides the same as an outer join, just a few more steps to get there.

Regards,

Bill
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now