--点击修改时辅助输入法查询的不是手术的跟踪

Select  
from (select ssmc00,pysm00,wbsm00,cm3000,ssbh00,ssdjmc,dj0000 from vw_bm_sszd00 where (pysm00 Like '%' or ssbh00 Like '%') 
and ( ((fbbh00='1' and ybbrlb='0' and ybzxlb='0' and sfsfxm='Y') or (sfsfxm='N')) 
and SFBZDJ=0 
and (not exists (select 1 from XT_ZLXMFF where ZLXMID=SSBH00 and YXBZ00='1')
     or exists (select 1 from XT_ZLXMFF where ZLXMID=SSBH00 and YYID00='0' and YXBZ00='1'))  )  
order by ssbh00,pysm00) where Rownum=100

--正常查询手术的跟踪
Select  
from (select ssmc00,pysm00,wbsm00,cm3000,ssbh00,ssdjmc,dj0000 from vw_bm_sszd00 where (pysm00 Like '%' or ssbh00 Like '%')
 and ( ((fbbh00='1' and ybbrlb='0' and ybzxlb='0' and sfsfxm='Y') or (sfsfxm='N')) 
 and SFBZDJ=0 
 and (not exists (select 1 from XT_ZLXMFF where ZLXMID=SSBH00 and YXBZ00='1') 
 or exists (select 1 from XT_ZLXMFF where ZLXMID=SSBH00 and YYID00='220007' and YXBZ00='1'))  ) 
  order by ssbh00,pysm00) where Rownum=100