select a.*,(select BMMC00 from BM_BMBM00 where BMBH00=a.KDKS00) KDKSMC  from (
 SELECT S.XMMC00,M.XMDW00 DW0000,M.XMDJ00 SFJE00,SUM(M.XMSL00)SL0000,SUM(M.HJJE00)HJJE00,SUBSTR(F.CZRQ00,1,6)CZRQ00,
 P.XMMC00 FPXMMC,KDKS00 FROM   ZY_FYMX00 M,ZY_BRFY00  F,BM_YYSFXM S,BM_YGBM00 Y,ZY_BRXXB0 B,BM_YPLB00 L,BM_FPXM00 P 
 WHERE  M.DJH000=F.DJH000 AND M.XMBH00=S.SFXMID AND S.SFXMID=L.SFDM00(+) AND S.ZYFPID=P.FPXMID AND F.ZYID00=B.ZYID00 
 AND F.CZY000=Y.YGBH00  AND F.CZRQ00 BETWEEN ? AND ?
 AND M.KDBQ00=? 
GROUP BY KDKS00,S.XMMC00,M.XMDW00,SUBSTR(F.CZRQ00,1,6),M.XMDJ00,P.XMMC00
 order by p.xmmc00,SUBSTR(F.CZRQ00,1,6),s.xmmc00
) a