SELECT B.物资编码, C.费用类别, C.费用明细, C.物资名称, C.型号规格, C.单位, B.总入库数, B.总入库金额, B.总出库数, B.总出库金额, B.总入库数-B.总出库数 AS 库存数, B.总入库金额-B.总出库金额 AS 库存金额
FROM [SELECT A.物资编码, Sum(A.入库数) AS 总入库数, Sum(A.入库金额) AS 总入库金额, Sum(A.出库数) AS 总出库数, Sum(A.出库金额) AS 总出库金额
FROM(SELECT 物资编码, Sum(入库数量) AS 入库数, Sum(金额) AS 入库金额, 0 AS 出库数, 0 AS 出库金额 FROM 入库单 GROUP BY 物资编码
UNION ALL SELECT 物资编码, 0, 0, Sum(出库数量), Sum(金额) FROM 出库单 GROUP BY 物资编码) AS A
GROUP BY A.物资编码]. AS B INNER JOIN 材料编码表 AS C ON B.物资编码 = C.物资编码;
SELECT 进出库明细表.物资编码, 进出库明细表.费用类别, 进出库明细表.费用明细, 进出库明细表.物资名称, 进出库明细表.型号规格, 进出库明细表.单位, 进出库明细表.总入库数, 进出库明细表.总入库金额, 进出库明细表.总出库数, 进出库明细表.总出库金额, 进出库明细表.库存数, 进出库明细表.库存金额
FROM 进出库明细表
WHERE (((进出库明细表.库存数)<>0));
能不能把这两段代码合成一段呢？我想在Excel中也可以使用。谢谢
点击下载此附件