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"));
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
ASKER CERTIFIED SOLUTION
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.
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";
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