[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Outer join in access

Posted on 2001-08-27
1
Medium Priority
?
561 Views
Last Modified: 2006-11-17
what i knew is access support right and left join, but does it support outer join on 2 tables ? meant that each of the table doesn't need to have value or match to other table. does it called outer join ? can it be done in access ?
0
Comment
Question by:Explorer060599
1 Comment
 
LVL 54

Accepted Solution

by:
nico5038 earned 200 total points
ID: 6430885
Already answered it in parts yourself.
Just create a query with a LEFT and one with a RIGHT join, both with a test or the key of the "optional side" is empty.
These only needs to be "concatenated" by a UNION and you have a "full outer join".

Clear ?

Nic;o)
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

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

If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

834 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