SELECT *FROM (  select * from VW_ZS_ZLXMSRF_DZBL_DJBZ A where 1=1  and a.sfbzdj = sf_xt_getsfdjbybmbh(173) and  UPPER(pysm00) like 'SGN%' and zlxmbh like 'Z004%' and (mzzybz in ('1','2') or mzzybz=3 and a.zlxmid in (select zlxmid from xt_kskdxm where zlxmid=a.zlxmid and kdksbh =173)) order by pxxh00,pysm00) WHERE ROWNUM<=100
select * from bm_zlzd00 where  ZLXMID =22966
select '0' XZ0000,a.ZLXMID,a.ZLXMJC,a.BBID00,a.BBMC00,nvl(a.SFJE00,0) SFJE00,a.GJBZBM,a.GJBZMC from VW_ZS_ZLXMSRF_DZBL_DJBZ a ,XT_ZHMX00 b where a.ZLXMID = b.ZLXMID and b.ZHXMID = 22966 order by b.MXXH00