Do more with
SELECT SWD_NDIC.*
,SWD_SCADA_Daily.*
,SWD_NDIC.[Well Name]
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_SCADA_Daily.[Well Name]) = "Test")
AND ((SWD_NDIC.[Well Name]) = "Test")
)
UNION
SELECT SWD_NDIC.*
,SWD_SCADA_Daily.*
,SWD_NDIC.[Well Name]
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])
WHERE (
((SWD_SCADA_Daily.[Well Name]) = "Test")
AND ((SWD_NDIC.[Well Name]) = "Test")
);
Premium Content
You need an Expert Office subscription to comment.Start Free Trial