select c.cWhname 仓库,a.cInvCode 存货编码,a.cInvName 存货名称,a.cInvStd 规格型号,a.iInvBatch 最小包装量,a.iTopSum 最高库存,
a.iLowSum 最低库存,b.cBatch 批次号,d.cComUnitName 主计量单位,b.dVDate 失效日期,sum(b.iQuantity)合计库存,
datediff(day,getdate(),isnull(b.dVDate,''))保质期
from Inventory a left join CurrentStock b on b.cInvCode=a.cInvCode
left join Warehouse c on b.cwhcode=c.cWhCode
left join ComputationUnit d on a.cComUnitCode=d.cComUnitCode
where b.cWhCode in ('W5101','W510106') and b.iQuantity > 0
group by a.cInvCode,c.cWhName,a.cInvName,a.cInvStd,a.iInvBatch,a.iTopSum,a.iLowSum,b.cBatch,d.cComUnitName,b.dVDate