22,207
社区成员
发帖
与我相关
我的任务
分享
[code=html]3663333333333333333
[/code]SELECT s.F_AreaID ,
ISNULL(s.Storage_in_quantity, 0) AS Storage_in_quantity , -- 库存数量
o.OrderNumber -- 订单数量
FROM ( SELECT F_AreaID ,
SUM(Storage_in_quantity) AS Storage_in_quantity
FROM Storage
GROUP BY F_AreaID
) s
RIGHT JOIN ( SELECT F_AreaID ,
SUM(OrderNumber) OrderNumber
FROM orderRecord
WHERE orderStalc = 1
GROUP BY F_AreaID
) o ON s.F_AreaID = o.F_AreaID;
SELECT s.F_AreaID,
s.Storage_Number, -- 库存数量
o.OrderNumber -- 订单数量
FROM Storage s
JOIN (
SELECT F_AreaID,
SUM(OrderNumber) OrderNumber
FROM orderRecord
WHERE orderStalc = 1
GROUP BY F_AreaID
) o
ON s.F_AreaID = o.F_AreaID