[AccessD] Basic Question

Keith Williamson Kwilliamson at RTKL.com
Wed May 27 12:10:23 CDT 2009


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.




More information about the AccessD mailing list