22,210
社区成员
发帖
与我相关
我的任务
分享
SELECT b.num ,
A.ProName ,
B.addquantity ,
b.MinusQuantity
FROM dbo.TB A
INNER JOIN ( SELECT ISNULL(a.num, b.num) AS num ,
ISNULL(A.addquantity, 0) AS addquantity ,
ISNULL(B.MinusQuantity, 0) AS MinusQuantity
FROM [入库] A
FULL JOIN [销售] B ON A.num = B.num
) B ON A.num = b.num
/*
num ProName addquantity MinusQuantity
001 产品1 11 22
002 产品2 12 35
004 产品4 16 0
005 产品5 0 56*/
SELECT b.num,b.ProName,ISNULL(A.AddQuantity,0) AS AddQuantity,ISNULL(M.MinusQuantity,0) AS MinusQuantity
FROM '基础表' AS B
INNER JOIN 入库 AS A
ON B.Num = A.Num
INNER JOIN 销售 AS M
ON B.Num = M.Num