Full Outer Joins

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
 
J

John Vinson

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.
 
Top