检查生成条码是否有问题

 select  * from SCPTINFO  WHERE SCPTINFO_ZHM NOT IN(SELECT  isnull(组合码,'') FROM ningdaMES.DBO.车间配送明细)
 and SCPTINFO_ZHM like '%M1'   and SCPTINFO_ZHM NOT like 'HS%M1' 
 AND SCPTINFO_ZHM IN(SELECT  组合码 FROM V_配托未收入)