468,733 Members | 1,545 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,733 developers. It's quick & easy.

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
Nov 12 '05 #1
2 2438
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

Nov 12 '05 #2
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

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Gary Wachs | last post: by
13 posts views Thread by Elaine | last post: by
2 posts views Thread by Fendi Baba | last post: by
13 posts views Thread by john | last post: by
NeoPa
reply views Thread by NeoPa | last post: by
7 posts views Thread by bkdraper via AccessMonster.com | last post: by
9 posts views Thread by shapper | last post: by
36 posts views Thread by TC | last post: by
reply views Thread by zhoujie | last post: by
xarzu
2 posts views Thread by xarzu | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.