这里单独查询是有数据的,如图,为什么联合起来数据就缺失了 语句如下: select sds.cInvCode as 存货编码,sds.cfree1 as 色号, sum(sds.iQuantity) as 销售订单数量, sum(sds.iFHQuantity )as 累计发货数量,sum(sds.iQuantity) - sum(sds.iFHQuantity ) as 销售订单未开单数量 ,sds.cInvName as 存货名称 into ##tmp3 from SO_SOMain sm left join SO_SODetails sds on sm.id=sds.ID --销售订单主表/子表 数据正确 where sm.dclosedate is null group by sds.cInvCode,sds.cfree1 ,sds.cInvName select sum(dls.fOutQuantity) as 总累计出库数量,dls.cinvcode as 存货编码,dls.cfree1 as 色号,dls.cinvname as 存货名称 into ##tmp1 from DispatchLists dls left join SO_SODetails sds on dls .cSoCode=sds.cSOCode left join SO_SOMain sm on sm.ID=sds.ID where dls.cordercode is not null and sm.dclosedate is null --订单未关闭以及销售订单不为空 group by dls.cinvcode , dls.cfree1 ,dls.cinvname --发货单表 select * from ##tmp3 left join ##tmp1 on ##tmp3.存货名称=##tmp1.存货名称 and ##tmp3.色号=##tmp1.色号
|