[AccessD] Basic Question

Jim Lawrence accessd at shaw.ca
Wed May 27 16:03:51 CDT 2009


Not sure if this is right with Access as my BE is generally anything but an
MDB but the UNION join has two options:

UNION (only unique)
UNION ALL (all)

Would this be the case?

Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Keith Williamson
Sent: Wednesday, May 27, 2009 10:10 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Basic Question

Hey gurus,

I have a basic question for you.  Quite a few times, in the past, I've
used Union Join queries to join different queries into common data.  For
instance:

select [WBS1], [SumOfFeeBillingCurrency] as [BeginFee], 0 as [EndFee]
from [qryReportingBacklogFeeBegin]

UNION select [WBS1], 0 as [BeginFee], [SumOfFeeBillingCurrency] as
[EndFee] from [qryReportingBacklogFeeEnd];

Recently I was testing one.....and discovered that my data result was
not correct.  I was thinking that with the union join, if one dataset
did not have matching data, to the other...I would only get one line of
data.  Otherwise, I should get two lines....which I then summarized in
another query of this union join.  However, I found that I only got data
from the datasets, where the select occurred in BOTH sets...([WBS1], in
the above scenario.)  Is that right??  

Keith Williamson | Associate, Asst. Controller | kwilliamson at rtkl.com 

RTKL Associates Inc. | 901 South Bond St. | Baltimore, MD  21231

410.537.6098 Direct | 410.276.4232 Fax | www.rtkl.com


--------------------------------------------------------------------------
The information contained in this communication is confidential, may be
privileged and is intended for the exclusive use of the above named
addressee(s). If you are not the intended recipient(s), you are expressly
prohibited from copying, distributing, disseminating, or in any other way
using any of the information contained within this communication. If you
have received this communication in error, please contact the sender by
telephone at (410) 537-6000 or by response via e-mail and permanently delete
the original email and any copies.

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list