Mar 12, 2003 #1 eyhandle Programmer Joined Feb 24, 2003 Messages 17 Location US 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.
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.
Mar 13, 2003 #2 danvlas Programmer Joined Jul 30, 2002 Messages 2,446 Location RO 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 Upvote 0 Downvote
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