怎样求库存量

1 先做一个联合查询 "库存量增减一览 查询"

SELECT 产品编号, 期初数量 as 数量, 库位,1 as biaohao
FROM 期初库存量表;

union select all 产品编号, 入库数量 as 数量, 库位,2 as biaohao
FROM 入库记录表;

union select all 产品编号,-出库数量 as 数量, 库位,3 as biaohao
FROM 出库记录表;

UNION select all 产品编号,-库位移出数量+库位移入数量 as 数量 , 库位, 4 as biaohao
FROM 库存库位调整表;

2 然后做一个汇总查询"库存量 查询"

SELECT DISTINCTROW [库存量增减一览 查询].产品编号, Sum([库存量增减一览 查询].数量) AS 现库存数量
FROM [库存量增减一览 查询]
GROUP BY [库存量增减一览 查询].产品编号;

点击下载此附件