统计结果跟踪：
select z.* ,s.xmmc00 from (  select sum(je0000) je0000,sum(sl0000) sl0000,sfxmid,count(1) TS0000 from  (select j.sfxmid,j.jjje00*j.sfcs00*j.sl0000 je0000,j.sl0000 from yj_yw0000 a,zy_brfy00 b,yj_ywjj00 j  where a.sfdjh0=b.djh000 and a.kdrq00>='20190611' and a.kdrq00<='20190613'   and a.xmzt00 in ('2','3','4') and a.mzzybz='1' and a.yjksbh+0='118' and a.yjdjh0=j.yjdjh0  union all  select j.sfxmid,j.jjje00*j.sfcs00*j.sl0000 je0000,j.sl0000 from yj_yw0000 a,sf_brfy00 b,yj_ywjj00 j   where a.sfdjh0=b.djh000 and a.kdrq00>='20190611' and a.kdrq00<='20190611'    and a.xmzt00 in ('2','3','4') and a.mzzybz<>'1' and a.yjksbh+0='118' and a.yjdjh0=j.yjdjh0 ) y  group by sfxmid )z,bm_yysfxm s where s.sfxmid(+)=z.sfxmid order by s.xmmc00

明细查询跟踪：
select z.*  from (
  select j.sfxmid,j.jjje00*j.sfcs00*j.sl0000 zje000,j.sl0000, 
         (select XMMC00 from BM_YYSFXM where SFXMID=j.SFXMID)  XMMC00, 
         (select BMMC00 from BM_BMBM00 where BMBH00=a.KDBQ00) KDBQMC, 
         a.BRXM00,a.KDRQ00,a.KDYSXM,a.ZYHGHH,j.jjje00*j.sfcs00 DJ0000 
          from yj_yw0000 a,zy_brfy00 b,yj_ywjj00 j                       
        where a.sfdjh0=b.djh000 and a.kdrq00>='20190611' and a.kdrq00<='20190613'   
        and a.xmzt00 in ('2','3','4') and a.mzzybz='1' and a.yjksbh+0='118' and a.yjdjh0=j.yjdjh0    
        and j.SFXMID in (8000065300)       
     union all      
     select j.sfxmid,j.jjje00*j.sfcs00*j.sl0000 Zje000,j.sl0000,  
         (select XMMC00 from BM_YYSFXM where SFXMID=j.SFXMID)  XMMC00,   
         (select BMMC00 from BM_BMBM00 where BMBH00=a.KDKSBH) KDBQMC,   
         a.BRXM00,a.KDRQ00,a.KDYSXM,a.ZYHGHH,j.jjje00*j.sfcs00 DJ0000    
      from yj_yw0000 a,sf_brfy00 b,yj_ywjj00 j                         
        where a.sfdjh0=b.djh000 and a.kdrq00>='20190611' and a.kdrq00<='20190613'    
        and a.xmzt00 in ('2','3','4') and a.mzzybz<>'1' and a.yjksbh+0='118' and a.yjdjh0=j.yjdjh0    
        and j.SFXMID in (8000065300)     
 ) z                                      
 order by z.xmmc00,kdbqmc,kdysxm