Question about Joins in Access

[FrankMoore]

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

[Larry Linson]

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" <fr*********@fmr.com> wrote in message
news:a3**************************@posting.google.c om...

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

[Bas Cost Budde]

FrankMoore wrote:

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

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

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