select '0' CHECK0,A.*,(SELECT SCCJZW FROM BM_YPSCCJ B WHERE A.SCCJBH=B.SCCJBH) as SCCJ00,(SELECT YLMC00 from BM_YPYL00 WHERE LBBH00=a.LBBH00 AND YLBH00=a.YLBH00) YLMC00
 from BM_YD0000 A
 where LBBH00 like '0%'
 and YLBH00 like '%'
 and JXBH00 like '%'
 and PDXH00<>'0' 
 and TZRQ00 IS NULL and ypnm00='26'
 and YPNM00 NOT IN 
 (SELECT XMBH00 FROM BM_XMBZ00 WHERE ybzxlb='1' and bh0000='000001000001'
  and type00='0' )order by YPBM00 


¸ÃÓï¾ä NOT IN ¸ÄΪ NOT EXISTS