首页 > 代码库 > 【数据处理】20商品销售匹配
【数据处理】20商品销售匹配
select a.pluno,a.pluname,a.spec,a.qty,d.qty,e.qty,a.dptno,substring(a.dptno,1,3),f.dptname,substring(a.dptno,1,4),g.dptname,substring(a.dptno,1,5),h.dptname
from lhxs201402 a
left join lhspm b on a.pluno=b.pluid
left join xbspm c on b.barcode=c.bcd
left join (select pluno,sum(qty) qty from xbxs where rq between ‘20140601‘ and ‘20140914‘ group by pluno ) d on c.pluno=d.pluno
left join (select pluno,sum(qty) qty from dbxs where rq between ‘20140601‘ and ‘20140914‘ group by pluno ) e on c.pluno=e.pluno
left join lhflm f on substring(a.dptno,1,3)=f.dptno
left join lhflm g on substring(a.dptno,1,4)=g.dptno
left join lhflm h on substring(a.dptno,1,5)=h.dptno
【数据处理】20商品销售匹配
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。