AnotherJob
Programmer
What's the best way to implement a FULL JOIN in Jet SQL? Currently I'm using the distinct union of a LEFT OUTER JOIN and RIGHT OUTER JOIN. Is there a more efficient way?
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
SELECT Name, Employee-ID, Address
FROM Table1
LEFT JOIN Table2 ON Table1.Employee-ID = Table2.EmployeeID
UNION
SELECT Name, Employee-ID, Address
FROM Table2
LEFT JOIN Table1 ON Table2.Employee-ID = Table1.EmployeeID
SELECT Name, [b]Table1.[/b]Employee-ID, Address
FROM Table1
LEFT JOIN Table2 ON Table1.Employee-ID = Table2.EmployeeID
UNION ALL
SELECT Name, [b]Table2[/b].Employee-ID, Address
FROM Table2
LEFT JOIN Table1 ON Table2.Employee-ID = Table1.EmployeeID
[b]Where Table1.Employee-ID IsNULL[/b]
I can't seem to extend it to cover additional tables