simulate full outer join

[oate3572]

I have two very simple tables, with a common field on which I need to perform an outer join, so that I can return a combined list of all the records from both tables.

I've read somewhere that Access does not support ful

 

[oate3572]

sorry - accidental key press. What I meant to say was that I have been led to believe that Access does not support full outer joins. Is this true?

If it is true, are there any work arounds?

thanks

 

[swampBoogie]

It's true, it is not supported.

A full outer join is a shorthand for

select a inner join b on a.pk = b.pk
union all
select a left outer join b on a.pk = b.pk
where b.pk is null
union all
select b left outer join a on b.pk = a.pk
where a.pk is null

 

[oate3572]

thanks swampboogie. That's got me out of a tight spot. Being able to use the shorthand method would be nice, but I guess we can't have everything!

cheers