求两张表相同字段的和?

roy78 发布于 2008-01-12 09:39， 1413 次点击

表1 有"重量"字段表2 也有"重量"字段 ,求条语句为两张表,表1.SUM(重量) + 表2.SUM(重量)

4 回复

XieLi2008-01-14 09:47

DECLARE @T TABLE (ID1 INT)

DECLARE @TT TABLE (ID2 INT)

INSERT INTO @T SELECT 12
UNION ALL SELECT 22

INSERT INTO @TT SELECT 23
UNION ALL SELECT 33

--最后结果
SELECT (A.ID1+B.ID2) AS SUMS FROM
(SELECT SUM(ID1) AS ID1 FROM @T) A,
(SELECT SUM(ID2) AS ID2 FROM @TT)B

roy782008-01-14 21:36

谢谢,您幸苦了.

wgyjx2008-04-01 10:07

多表求和的问题，能详细地说清楚？