Hello,
Is there an easier way to do full outer join in Access compare to SQL server.
In Access we need to to left join then right join where left table is null then union them.
This becomes very cumbersome if we have 4 tables that need to do the full outer join to.
Please advise !