Full outer join in Access (1 Viewer)

J

jaryszek

Registered User.

Local time

Yesterday, 20:37

Joined

Aug 25, 2016

Messages

756

• Feb 21, 2019

• #1

Hi,

i would like to write opposite of inner join in Access:

Code:Copy to clipboard

SELECT tblDataCenters.*
FROM [ExportDataCenters-NEW] INNER JOIN tblDataCenters ON ([ExportDataCenters-NEW].LocationID = tblDataCenters.LocationID) AND ([ExportDataCenters-NEW].DataCenter = tblDataCenters.DataCenter);

i do not want to get common records between these 2 tables but uncommon records.
How can i do this in easy way? Do you have any solution for that?

Best,
Jacek

 

Minty

AWF VIP

Local time

Today, 04:37

Joined

Jul 26, 2013

Messages

10,371

• Feb 21, 2019

• #2

As far as I'm aware there is no such thing as a Full Outer Join in access.

I use them occasionally in SQL Server to produce exception lists when comparing multiple data tables with the same structure.

You could build a number of queries and use a temp table to effectively build the same result as a Full Outer Join, but it's a bit involved.

 

isladogs

MVP / VIP

Local time

Today, 04:37

Joined

Jan 14, 2017

Messages

18,218

• Feb 21, 2019

• #3

Use an unmatched left outer join and union it with an unmatched right outer join....or use sql server which supports full outer joins

 

J

jaryszek

Registered User.

Local time

Yesterday, 20:37

Joined

Aug 25, 2016

Messages

756

• Feb 21, 2019

• #4

thank you Guys,

hmm i have to try to use this.

Best,
Jacek