Adding two sums? 1

[hapax]

So far I have SQL code that gives me two different SUMs in two different queries.

Now I want to add the two SUMs. How do I do that?

 

[PHV]

Why not posting the two SQL code ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[hapax]

OK, here they are:

select
agingdetail.customerid,
SUM(agingdetail.totaldue) as sum
from agingdetail
where agingdetail.totaldue <> 0
group by agingdetail.customerid
order by agingdetail.customerid


select
aradjustment.customerid,
SUM(aradjustment.totalamount) as sumAdjustments
from aradjustment
where
aradjustment.totalamount <> 0
group by aradjustment.customerid
order by aradjustment.customerid

 

[PHV]

You may try this:

SELECT customerid, SUM(total) AS Grandtotal
FROM (
SELECT customerid, totaldue AS total FROM agingdetail
UNION ALL SELECT customerid, totalamount FROM aradjustment
)
GROUP BY customerid
ORDER BY customerid

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[hapax]

When I try this in SQL Server 2005, I get this error:

Msg 156, Level 15, State 1, Line 6
Incorrect syntax near the keyword 'GROUP'.

 

[PHV]

As you posted in the ANSI SQL forum you've got such answer.
I don't know SQL server 2005's ANSI compliance, but I'd try this:

SELECT customerid, SUM(total) AS Grandtotal
FROM (
SELECT customerid, totaldue AS total FROM agingdetail
UNION ALL SELECT customerid, totalamount FROM aradjustment
) [!]AS U[/!]
GROUP BY customerid
ORDER BY customerid

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[hapax]

Excellent, that works.

Many thanks, PH