Re: Help With SELECT Statement

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

That works! Thanks!

"Jens" <Jens@xxxxxxxxxxxxxxxx> wrote in message
news:1134740480.594260.197120@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> SELECT ContactName, SUM(SumAmount)
> FROM
> (
> SELECT tblContacts.ContactName, Sum(tblInvoices.InvoiceAmount) AS
> SumAmount
> FROM tblContacts RIGHT JOIN tblInvoices ON tblContacts.ContactID =
> tblInvoices.ContactID
> GROUP BY tblContacts.ContactName
> UNION ALL SELECT tblContacts.ContactName,
> Sum(tblPayments.PaymentAmount) AS SumAmount
> FROM tblContacts RIGHT JOIN tblPayments ON tblContacts.ContactID =
> tblPayments.ContactID
> GROUP BY tblContacts.ContactName
> )
> GROUP BY ContactName
>
> HTH, jens Suessmeyer.
>


.

Relevant Pages

  • Re: Help With SELECT Statement
    ... SELECT ContactName, SUM ... FROM tblContacts RIGHT JOIN tblInvoices ON tblContacts.ContactID = ... SumAS SumAmount ...
    (microsoft.public.sqlserver)
  • Re: concatenating fields in an SQL query
    ... > get a nieuw field ContactName to select in dropdownbox. ... > If one of the 3 fields is empty i get an empty ContactName string back. ... > tblContacts.*, ...
    (borland.public.delphi.database.ado)
  • concatenating fields in an SQL query
    ... I'm trying to concatenate 3 fields: FirstName + MiddleName + LastName to get ... If one of the 3 fields is empty i get an empty ContactName string back. ... FROM tblContacts ... MiddleName, Text 10, Required = No, Allow Zero Length = Yes ...
    (borland.public.delphi.database.ado)
  • Re: How do I find duplicates in Access 2002 without the install cd-rom
    ... SELECT ContactName, Countas NumOf ... FROM tblContacts ... MS Access MVP ...
    (microsoft.public.access.queries)