--住院跟踪【有问题】

Select * from (select MC0000,PY0000,WB0000,XXZDID,SFMC00,DSMC00 from BM_BRXXZD
where (PY0000 Like '%') and( SFYX00='Y' and ZDLB00=4 and (FJDID0=0 OR FJDID0=0) ) Order By PY0000) where Rownum<=100


----以下是门诊跟踪【没有问题】
select * from xt_xtcs00 where name00='SF_DZRSFYXSDSR' or bz0000 like '%地址%'
Select * from (select MC0000,PY0000,WB0000,XXZDID from BM_BRXXZD where (PY0000 Like ?)
and( SFYX00='Y' and ZDLB00=4 and (FJDID0=0 OR FJDID0=7851) ) Order By PY0000) where Rownum<=100