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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Full Outer Join Question 3
Need to do a full outer join 3
JOIN questions 3
A bug in GUI of creating query with more outer joins between two tables 5
Relationship - Outer Join - Microsoft Access 2002 1
Full Outer Join 4
How realizing 'full outer join' from ADP in MDB 3
parent child link query 1

Back
Top