Select 组装车间,排产单号,单据编号,产品代码,产品名称,{订单表}.规格型号,购货单位,销售方式,数量,入仓数量,未入仓数量,未出数量,基本计量单位数量 As [库存数量] From {订单表} Inner JOIN (select 单据编号,产品代码,max([_Identify]) as [_Identify] from {订单表} group by 单据编号,产品代码) as b on {订单表}.[_Identify] = b.[_Identify] Inner JOIN {即时库存} ON {即时库存}.[物料代码] = {订单表}.[产品代码] Where 类型 = '库存' and 关闭标志 is null and 完成入仓 = 0 and 组装车间_完成 = 0