怎样做4个表的数据汇总?

[wanjun_003]

有4个表,分别是t1,t2,t3,t4

每一个表都有一个金额列

现在要算出总金额:

sum(t1.金额) + sum(t2.金额) + sum(t3.金额) + sum(t4.金额)

-------------------------------------------------------------

请问sql该怎么写?谢谢

[zsl5305256]

select sum(金额) from
(
select sum(t1.金额) as 金额 from table1
union all
select sum(t2.金额) from table2
union all
select sum(t3.金额) from table3
union all
select sum(t4.金额) from table4

) a

[bqb]

select sum(金额) from

(select * from t1
union all
select * from t2
union all
select * from t3
union all
select * from t4
) a

[marco08]

select sum(金额) as 金额 from
(
select sum(金额) as 金额 from T1
union all
select sum(金额) from T2
union all
select sum(金额) from T3
union all
select sum(金额) from T4
)

[wanjun_003]

多谢大家