[AccessD] A2003: Left Join problem

Steve Erbach erbachs at gmail.com
Mon Apr 25 12:39:37 CDT 2005


Jeffrey,

Ah! All in one query! I can get rid of my saved query. I wasn't aware
that a subquery could be given an alias like a field can. Thank you.

Steve Erbach

On 4/25/05, jeffrey.demulling at usbank.com <jeffrey.demulling at usbank.com> wrote:
> You can try this:
> 
> SELECT
>   DonationCategories.CategoryDescr,
>   temp1.SumOfDonations
> FROM DonationCategories
> LEFT JOIN
> 
> (SELECT
>   DollarsDonated.CategoryKey,
>   Sum(DollarsDonated.DonationAmount) as SumOfDonations
> FROM DollarsDonated
> WHERE (((DollarsDonated.ReceiptDate) Between #1/1/2005# And #3/31/2005#))
> GROUP BY DollarsDonated.CategoryKey) AS temp1
> 
> ON DonationCategories.CategoryKey = temp1.CategoryKey
> 
> Jeffrey F. Demulling



More information about the AccessD mailing list