Full Join

[Bill Smyth]

Is there not an easy way to do a FULL OUTER join in
Access 2002?

 

[John Spencer (MVP)]

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.

 

[Van T. Dinh]

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.

 

[Peter Surcouf]

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