sql-server - 如何比较两个sql查询值

Question

我有两个表 StockOutward 和 product outward..我必须获取不等于 sum(qty) stockOutward 的 sum(qty)..

StockOutward

Id ProductId Qty Location Orderid1     7       2     2        382     8       1     2        383     7       1     2        38

ProductOutward

Id ProductId Qty Location Orderid1     7       12     2        382     8        1     2        38

I need the output from stockoutward as ProductId 7

I have used the below query

Select
    sum(qty) as Qty,ProductId 
from 
    StockOutward 
where 
    Orderid='38' 
group by 
    ProductId 

Union

Select 
    sum(qty) as Qty,
    ProductId 
from 
    ProductOutward 
where 
    Orderid='38' 
group by 
    ProductId

Answer 1

您可以使用 JOIN 并过滤不等式:

SELECT
    s.ProductId
FROM (
    SELECT
        ProductId,
        SumQty = SUM(Qty)
    FROM StockOutward
    GROUP BY ProductId
)s
INNER JOIN (
    SELECT
        ProductId,
        SumQty = SUM(Qty)
    FROM ProductOutward
    GROUP BY ProductId
)p
    ON p.ProductId = s.ProductId
    AND p.SumQty <> s.SumQty