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
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
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";
Access Full Outer Join