Avatar of Aiysha
Aiysha
Flag for United States of America asked on

full join in access query

How do I implement full join in access. I want to see data from both table joined by two fields.

SELECT SWD_NDIC.*, SWD_SCADA_Daily.*, SWD_NDIC.[Well Name]
FROM SWD_NDIC full JOIN SWD_SCADA_Daily ON (SWD_NDIC.[Well Name] = SWD_SCADA_Daily.[Well Name]) AND (SWD_NDIC.Date = SWD_SCADA_Daily.[Time/Date])
WHERE (((SWD_SCADA_Daily.[Well Name])="Test") AND ((SWD_NDIC.[Well Name])="Test"));
Microsoft AccessSQL

Avatar of undefined
Last Comment
Aiysha

8/22/2022 - Mon
Anders Ebro (Microsoft MVP)

I suggest you take a look at this tutorial on a workaround for a full outer join in access:
Access Full Outer Join
ASKER CERTIFIED SOLUTION
John Tsioumpris

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Aiysha

ASKER
John,

Thank you so much for the details. Actually following worked for me:

SELECT SWD_NDIC.*, SWD_SCADA_Daily.*
FROM SWD_NDIC RIGHT JOIN SWD_SCADA_Daily ON (SWD_NDIC.[Well Name] = SWD_SCADA_Daily.[Well Name]) AND (SWD_NDIC.Date = SWD_SCADA_Daily.[Time/Date])
UNION SELECT SWD_NDIC.*, SWD_SCADA_Daily.*
FROM SWD_NDIC left JOIN SWD_SCADA_Daily ON (SWD_NDIC.[Well Name] = SWD_SCADA_Daily.[Well Name]) AND (SWD_NDIC.Date = SWD_SCADA_Daily.[Time/Date])
where swd_ndic.[Well NAme]="test" and SWD_SCADA_Daily.[Well Name]= "test";
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck