1       15:08:54  SQL Execute: ORACLE - select a.gxid00,a.zlxmid,a.sfxmid,c.xmmc00,a.gdbz00,a.BQSFBZ,trim(substr(C.bz0000,1,200)) BZ0000,a.FJFYBZ,a.sfcs00,a.mxxmid,a.JSXZ00,C.GG0000,(select XMNH00 from BM_YYSFXM where SFXMID=a.SFXMID) XMNH00, C.SFJE00,A.GJBM00,a.TYBZ00,a.SFLB00,C.DW0000,c.BH0000,c.JSXMMC,(SELECT YPBM00 FROM (SELECT A.SFXMID,MAX(B.YPBM00) YPBM00 FROM BM_WZQTXX A,BM_YD0000 B WHERE A.YPNM00 = B.YPNM00 GROUP BY A.SFXMID) D WHERE D.SFXMID = C.SFXMID) YPBM00  ,(SELECT DISTINCT YPMC00 FROM (SELECT A.SFXMID,B.YPMC00,MAX(B.YPBM00) YPBM00 FROM BM_WZQTXX A,BM_YD0000 B WHERE A.YPNM00 = B.YPNM00 GROUP BY A.SFXMID,B.YPMC00) D WHERE D.SFXMID = C.SFXMID) YPMC00,c.BKEH83,c.GJBZMC,b.LBBH00  ,C.GG0000,C.XMXH00,c.JSXM00  from XT_ZLSFGX a,BM_ZLZD00 B,VW_BM_YYSFXM_DJBZ C where a.zlxmid=b.zlxmid and a.sfxmid=c.sfxmid and B.ZLXMID=8000062574  and c.SFBZDJ=0 order by xmmc00