SELECT B.JYXMMC,B.JYXMBH, 
 (select JYJG00 from VW_XK_LISJG00 where MZZYBZ='1' and ZYGHID=A.ZYID00 AND BGXMID=B.BGXMID) AS JYJG00
 ,A.ZYID00,B.BGXMID FROM XK_SQDJG0 A,XK_JYBGXM B WHERE A.BGXMID(+)=B.BGXMID
 AND B.BGDJID=?   AND ZYID00(+)=? ORDER BY JYXMBH 

建议由上述语句改为如下语句

SELECT B.JYXMMC,B.JYXMBH, 
 (select JYJG00 from VW_XK_LISJG00 where MZZYBZ='1' and ZYGHID=? AND BGXMID=B.BGXMID and rownum=1) AS JYJG00
 ,A.ZYID00,B.BGXMID FROM XK_SQDJG0 A,XK_JYBGXM B WHERE A.BGXMID(+)=B.BGXMID
 AND B.BGDJID=?   AND ZYID00(+)=? ORDER BY JYXMBH