我在SQL Server中有两个表:
Product_Brought (
Product_ID, Quantity_Brought, ....
)
Product_Distribution (
Product_ID, Quantity_Sold, ....
)
我想通过计算两者之间的差异来计算这两张表中这两列的现有余额。我做了这样的事情,但它返回的是没有意义的事情。
SELECT
DIFFERENCE((SELECT sum(Quantity_Brought)
FROM
Product_Brought),
(SELECT sum(Quantity_Sold) FROM Product_Distribution))
您可以在子查询中计算SUM,然后进行减法。
SELECT T1.TotalBrought - T2.TotalSold as BalanceOnHand
FROM
(SELECT SUM(Quantity_Brought) as TotalBrought
FROM Product_Brought
) T1,
(SELECT SUM(Quantity_Sold) as TotalSold
FROM Product_Distribution
) T2
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句