Full Outer Joins

  • Thread starter Thread starter Mike Olson
  • Start date Start date
M

Mike Olson

I need to do a FULL OUTER JOIN between two tables, but
this apparently isn't supported in MS Access 2000. Does
anyone have a good workaround for this?

Thanks,
Mike Olson
 
I need to do a FULL OUTER JOIN between two tables, but
this apparently isn't supported in MS Access 2000. Does
anyone have a good workaround for this?
Click to expand...

A UNION query between a Left and a Right outer join is about as close
as you can get.
 
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
Relationship - Outer Join - Microsoft Access 2002 1
A bug in GUI of creating query with more outer joins between two tables 5
parent child link query 1
Full Outer Join 4
Ambiguous outer join 6
Need to do a full outer join 3
How realizing 'full outer join' from ADP in MDB 3

Back
Top