By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,392 Members | 1,556 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,392 IT Pros & Developers. It's quick & easy.

Question about Joins in Access

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
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.