full outer join?

[eyhandle]

is it possible to create a query in ACCESS using a full outer join?

i know how to create an left outer join.

i get errors when i try to create a full outer join.

 

[danvlas]

One left join query to return all records from table 1 and what's possible from table 2

One right join query with condition: Is Null for table 1

Union on both.

That should be it...

Good luck


Daniel Vlas
Systems Consultant