How to obtain sum from two tables. 1

[rpk2006]

Hi,

I have two tables with the same structure. Both tables have a field "Cost". I want that the sum total of "Cost" of on table and the sum total of "Cost" of the second table be added and stored in a variable. How to do that ?

Here is what I did, but it is not working...

Select sum(cost)+ sum(cost) as expr1 from Chemical, Glassware
There is always a new solution for the same problem.

Anonymous

 

[DaveStL]

Try:

Select sum(Chemical.cost)+ sum(Glassware.cost) as expr1
from Chemical, Glassware

 

[rac2]

I think DaveStL's query will give you the product of the sums from the two tables.

Here is a query that will give you a sum of the sums.

SELECT SUM(expr1) FROM
(
SELECT SUM( total_price ) AS expr1 FROM Chemical

UNION

SELECT SUM( total_price ) AS expr1 FROM Glassware
) anyOldAias

 

[rac2]

Sorry, I meant to write SUM( cost ).