核查处理车间配送掉数据清空

select  * from ningdaMES.dbo.车间条码 where 条码值='2309088165M1'
select  * from ningdaMES.dbo.车间配送明细 where 组合码='2309088165M1'
SELECT  * FROM SCPTINFO WHERE SCPTINFO_ZHM='2309088165M1'

insert into ningdaMES.dbo.车间配送(组合码,条码值,产品代号,生产线代码,扫描人,扫描时间,
厂家代码,厂家名称,零件代号,零件名称,宁江批次,收入数量,特殊库存,配送单号,货位号,颜色)
SELECT  SCPTINFO_ZHM,SCPTINFO_TMH,SCPTINFO_CPBH,SCPTINFO_SCX,打印人,打印时间,
SCPTINFO_DWBH,ZWWLDW_DWMC,SCPTINFO_WLBH,LSWLZD_WLMC,SCPTINFO_PCH,SCPTINFO_SL,SCPTINFO_WLTSKC,SCPTINFO_PSDH,SCPTINFO_HWBH,
case SCPTINFO_YS when 0 then '' else SCPTINFO_YS end
FROM SCPTINFO,LSWLZD,ningdaMES.dbo.车间条码,ZWWLDW WHERE LSWLZD_WLBH=SCPTINFO_WLBH and SCPTINFO_ZHM=条码值
and SCPTINFO_DWBH=ZWWLDW_DWBH
and  SCPTINFO_ZHM='2212000504M1'


 select  * from ningdaMES.dbo.车间条码(nolock) where isnull(条码值,'') not in(select  isnull(组合码,'') from ningdaMES.dbo.车间配送明细 )
 and isnull(备注,'')='' and 条码值 like '%M1'