ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 规格查找

规格查找

原创 Linux操作系统 作者:zaorv 时间:2019-02-23 18:42:06 0 删除 编辑

--库存拉链类规格与规格档案的规格不相同的记录.CSV
select md.mdmodel from model ,
( select f.code as code,s.model as mdmodel from stock s ,mmf f , model m where s.matid=f.matid and substring(f.code,1,1)='Q'
and s.qty>=1 and s.mpsid=''
union
select f.code as code,s.model as mdmodel from stock s ,mmf f , model m where s.matid=f.matid and substring(f.code,1,1)='Q'
and s.qty>=1 and s.mpsid='' ) as md
where model.name!=md.mdmodel
union
select md.mdmodel from model ,
( select f.code as code,s.model as mdmodel from stock s ,mmf f , model m where s.matid=f.matid and substring(f.code,1,1)='Q'
and s.qty>=1 and s.mpsid=''
union
select f.code as code,s.model as mdmodel from stock s ,mmf f , model m where s.matid=f.matid and substring(f.code,1,1)='Q'
and s.qty>=1 and s.mpsid='' ) as md
where model.name!=md.mdmodel

按仓库的需求。


来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/729024/viewspace-564844/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 无题
请登录后发表评论 登录
全部评论

注册时间:2018-09-12

  • 博文量
    192
  • 访问量
    146322