Solved

Outer join function in Access

Posted on 2003-12-11
3
1,948 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

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

743 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

9 Experts available now in Live!

Get 1:1 Help Now