1 """upd ate c set c.库存数量 = a.累计入库-b.累计出库 f rom (Se lect 物资名称, sum(数量) As 累计入库 f rom 物资明细 whe re 明细分类 = '入库' group by 物资名称) a, (Se lect 物资名称, sum(数量) As 累计出库 f rom 物资明细 wh ere 明细分类 = '出库' group by 物资名称) b,库存物资 c where a.物资名称=c.物资名称 And " & _"b.物资名称=c.物资名称 """"