Full Join

  • Thread starter Thread starter Bill Smyth
  • Start date Start date
No there is not. You need to do two Outer JOINs (LEFT JOIN OR RIGHT JOIN) and
THEN use a UNION query to combine the results.
 
Full Outer Joins are not available in JET SQL.

You need to UNION the LEFT OUTER JOIN and the RIGHT OUTER JOIN to simulate a
full outer Join.
 
I use access front end to a sql7 back end which means I can do a pass
through, would it not be possible to put the data in an MSDE backend and
then use pass through?

peter
 
Back
Top