Re: How add sums from different tables?
From: I.Vinikovetsky <ilia_at_wescom.kharkov.ua>
Date: Mon, 5 Apr 1993 11:05:22 GMT
Message-ID: <1993Apr5.110522.12034_at_wescom.kharkov.ua>
Date: Mon, 5 Apr 1993 11:05:22 GMT
Message-ID: <1993Apr5.110522.12034_at_wescom.kharkov.ua>
Hi!
Let you usea following way:
create view X(S) as
select sum(A) from A_tbl
union
select sum(B*C) from B_tbl
union
.......
;
select sum(S) from X;
It will result a sum you need.
Ilia Vinikovetsky, WESCOM inc., Kharkov, Ukraine Received on Mon Apr 05 1993 - 13:05:22 CEST