Solved

Outer join function in Access

Posted on 2003-12-11
3
1,957 Views
Last Modified: 2006-11-17
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
Comment
Question by:foward
  • 2
3 Comments
 
LVL 10

Expert Comment

by:jobrienct
ID: 9925856
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
 
LVL 10

Expert Comment

by:jobrienct
ID: 9925880
or just in case you know what you want: select * from a,b where a.id = b.id;

John
0
 
LVL 11

Accepted Solution

by:
BillPowell earned 125 total points
ID: 9925923
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

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now