oracle多个结果集拼接字符串

要求根据查询条件返回每个用户对于的欠费量、欠费金额、欠费次数、欠费期间（欠费期间是多个以,分割）

select     
m.yqzh,max(m.hz_mc),sum(m.sl),sum(m.yje),sum(m.num),max(m.dzms),
listagg(m.cbqijian , ',') within
 GROUP(
 order by m.yqzh) as qfqijian
 from  
( select max(ys.fyjl_yqzh) as yqzh,
       max(ys.fyjl_hz_mc) as hz_mc,
       sum(ys.fyjl_sl) as sl,
       sum(ys.fyjl_yje) as yje,
       max(ys.fyjl_lxdh) as lxdh,
       count(ys.fyjl_bi_id) as num,
       max(ys.fyjl_yqdz_ms) as dzms,
       max(substring(ys.fyjl_cbqijian,1,6)) as cbqijian
  from feiyong_jilu_ys ys
 where ys.fyjl_zt = '4'
   and ys.fyjl_fylx_id = '31'
   and ys.fyjl_fyxm_id = '3101'
   and ys.fyjl_yqzh='D6000107'
 group by ys.fyjl_bi_id
 ) m 
 group by m.yqzh

查询结果：
[img]http://dl.iteye.com/upload/picture/pic/132522/a36c7d6a-3c6b-3884-aea2-5e6822f95964.png[/img]