第1个回答 2017-11-09
SELECT BM.配件编号, RK.入库数量合计, CK.出库数量合计, RK.入库数量合计-CK.出库数量合计 AS 库存数量 FROM ((SELECT a.配件编号 FROM 出库信息表 as a UNION SELECT b.配件编号 FROM 入库信息表 as b) as BM LEFT JOIN (SELECT R.配件编号, Sum(R.入库数量) AS 入库数量合计 FROM 入库信息表 AS R GROUP BY R.配件编号) RK ON BM.配件编号 = RK.配件编号) LEFT JOIN (SELECT C.配件编号, Sum(C.出库数量) AS 出库数量合计 FROM 出库信息表 AS C GROUP BY C.配件编号) CK ON BM.配件编号 = CK.配件编号