22,210
社区成员
发帖
与我相关
我的任务
分享
SELECT
ISNULL((SELECT SUM(imoney) FROM 表1),0)+
ISNULL((SELECT SUM(imoney) FROM 表2),0)+
ISNULL((SELECT SUM(imoney) FROM 表3),0)
SELECT
(SELECT SUM(imoney) FROM 表1)+
(SELECT SUM(imoney) FROM 表2)+
(SELECT SUM(imoney) FROM 表3)
[/quote]
这个结果是空的,前面第一个表合计是有数据的,后面两个没有SELECT
(SELECT SUM(imoney) FROM 表1)+
(SELECT SUM(imoney) FROM 表2)+
(SELECT SUM(imoney) FROM 表3)
select s1=(select sum([表1字段]) from [表1]),
s2=(select sum([表2字段]) from [表2]),
s3=(select sum([表3字段]) from [表3])
SELECT
(SELECT SUM(imoney) FROM 表1),
(SELECT SUM(imoney) FROM 表2),
(SELECT SUM(imoney) FROM 表3)