• 微信公众号:美女很有趣。 工作之余,放松一下,关注即送10G+美女照片!

oracel中将子表中一个字段多条数据合并到主表的sql

开发技术 开发技术 6小时前 1次浏览
select f.* ,g.nsjgName, h.XCJZZZZ, h.XCJFZZZ
  from (select max(t.JGSY_NAMEs) JGSY_NAMEs,
               max(t.jgsy_gg) jgsy_gg,
               jgsy_code,
               sum(t.zcjzs) zcjzs,
               sum(t.fcjzs) fcjzs,
               listagg(t.pzwh, ',') within group(order by t.jgsy_code) pzwh,
               listagg(t.BEIZHU, ',') within group(order by t.jgsy_code) beizhu
          from s_zsys t
         where t.BLRESULT = '3'
           and substr(t.jgsy_code, 0, 6) = '320100'
         group by jgsy_code
         order by t.jgsy_code) f
  left join (select jgsy_parent_code,
                    listagg(jgsy_name, ',') within group(order by gen.jgsy_parent_code) nsjgName
               from jgsy_common gen
              where 1 = 1
                and gen.jgsy_type = '06'
              group by jgsy_parent_code) g
    on g.jgsy_parent_code = f.jgsy_code
  left join BMLDZS h
    on h.jgsy_code = f.jgsy_code;

--select * from jgsy_common  f where f.jgsy_parent_code='320100-01-10012'  and f.jgsy_type='06'

  


程序员灯塔
转载请注明原文链接:oracel中将子表中一个字段多条数据合并到主表的sql
喜欢 (0)