+-
我希望能够从两个SELECT查询中获取我在SUM()中生成的两个值,并减去这些值以获得结果(OutstandingFunds).
这些是我的两个SELECT查询：
声明(1)：
SELECT SUM(Cf.Amount) AS ClearedFunds
FROM (
SELECT Amount FROM PAYMENT1 WHERE `Status` = "Cleared"
UNION ALL
SELECT Amount FROM PAYMENT2 WHERE `Status` = "Cleared"
UNION ALL
SELECT Amount FROM PAYMENT3 WHERE `Status` = "Cleared") AS Cf;
声明(2)：
SELECT SUM(Price) AS TotalSales
FROM PROPERTY
WHERE Status = “Sold”;
感谢您的时间
最佳答案
如果您不需要显示总销售额和清算资金的单独小计,您可以这样做：
SELECT SUM(Total.`Price`) AS ClearedFunds
FROM (
SELECT `Price` FROM PROPERTY WHERE `Status` = 'Sold'
UNION ALL
SELECT (`Amount` * -1) AS `Price` FROM PAYMENT1 WHERE `Status` = 'Cleared'
UNION ALL
SELECT (`Amount` * -1) AS `Price` FROM PAYMENT2 WHERE `Status` = 'Cleared'
UNION ALL
SELECT (`Amount` * -1) AS `Price` FROM PAYMENT3 WHERE `Status` = 'Cleared'
) AS Total;
我假设你想在这里从总销售额中扣除已清算的资金.
点击查看更多相关文章
转载注明原文：MySQL – 想要从两个SELECT语句中减去两个SUM()值 - 乐贴网
