56,677
社区成员
发帖
与我相关
我的任务
分享
SELECT
SUM(Money1),SUM(Money2),SUM(Money3) FROM
(
SELECT
Money1,Money2,Money3
FROM
table1
UNION
SELECT
Money1,Money2,Money3
FROM
table2
) AS total;
SELECT
SUM(Money1),SUM(Money2) FROM
(
SELECT
Money1,Money2
FROM
table1
UNION
SELECT
Money1,Money2
FROM
table2
) AS total;