SELECT sum(A.价值) AS 总金额 FROM 表1 AS A
SELECT sum(B.交款金额) AS 已交金额 FROM 表2 AS B现在想写出一个求差值的SQL语句,显示如下:总金额, 已交金额, 总金额-已交金额求助高手相助!谢谢。
SELECT sum(B.交款金额) AS 已交金额 FROM 表2 AS B现在想写出一个求差值的SQL语句,显示如下:总金额, 已交金额, 总金额-已交金额求助高手相助!谢谢。
不知道是不是你想要的!
from( SELECT sum(A.价值) AS 总金额 FROM 表1 group by id ) A left join
( SELECT sum(B.交款金额) AS 已交金额 FROM 表2 group by id ) b no a.id=b.id
from(SELECT sum(A.价值) AS 总金额 FROM 表) a,
(SELECT sum(B.交款金额) AS 已交金额 FROM 表) b