Sum with nesting [message #1364] |
Wed, 24 April 2002 07:36 |
Mufaddal
Messages: 4 Registered: March 2002
|
Junior Member |
|
|
I have made three table i want sum of each column of a table and then total sum of column of all table.
E.g Table1 Table2 Table3
qty pqty sqty
sum(qty)t1qty , sum(pqty)t2pqty, sum(sqty)t3sqty
then sum(t1qty + t2pqty + t3sqty)
in single query
|
|
|
Re: Sum with nesting [message #1379 is a reply to message #1364] |
Thu, 25 April 2002 00:46 |
Epe
Messages: 99 Registered: March 2002
|
Member |
|
|
Hello,
if I understand your problem correctly, you almost gave the answer yourself. Try this :
select sum(qty)+sum(pqty)+sum(sqty)
from table1, table2, table3;
Success,
epe
|
|
|