Question about Joins in Access

Hi, I'm new to Access development and I'm running into a situation
that I can't find the elegant solution to and I'm hoping someone out
there can help. Where I'm at is that I have two tables that I want to
perform a FULL JOIN on and I can't seem to find a way to do this.

My fallback is that I know I can perform an INNER JOIN on the tables
to get the first part of information and then perform a LEFT JOIN
(what Access calls an Unmatched Query) to get the remainder and then
perform a union query to merge those two data sets together.

However, I like to avoid jumping through hoops needlessly. Any help
is appreciated.

Thanks,

Frank

Jet SQL does not have a "FULL JOIN".

A combination of JOINs and a UNION/UNION ALL should do what you want, and
isn't really a lot of trouble.

Larry Linson
Microsoft Access MVP

"FrankMoore" <frank.moore@fmr.com> wrote in message
news:a385d402.0402031254.11278d28@posting.google.c om...[color=blue]
> Hi, I'm new to Access development and I'm running into a situation
> that I can't find the elegant solution to and I'm hoping someone out
> there can help. Where I'm at is that I have two tables that I want to
> perform a FULL JOIN on and I can't seem to find a way to do this.
>
> My fallback is that I know I can perform an INNER JOIN on the tables
> to get the first part of information and then perform a LEFT JOIN
> (what Access calls an Unmatched Query) to get the remainder and then
> perform a union query to merge those two data sets together.
>
> However, I like to avoid jumping through hoops needlessly. Any help
> is appreciated.
>
> Thanks,
>
> Frank[/color]

FrankMoore wrote:[color=blue]
> I want to perform a FULL JOIN on and I can't seem to find a way to do this.
>
> My fallback is that I know I can perform an INNER JOIN on the tables
> to get the first part of information and then perform a LEFT JOIN
> (what Access calls an Unmatched Query) to get the remainder and then
> perform a union query to merge those two data sets together.
>
> However, I like to avoid jumping through hoops needlessly. Any help
> is appreciated.
>
> Thanks,
>
> Frank[/color]

What is a full join again? Isn't one UNION sufficient?

--
Bas Cost Budde
http://www.heuveltop.nl/BasCB