Love~jiaojiao的博客

不断学习,不断进步!

分组字符合并
select  A.xj_area_id,A.xj_area_name,A.code,B.personname from (select elearea.xj_area_id,elearea.xj_area_name,wm_concat(ele.code) code from  bus_elearea_info  elearea
left join bus_area_ele_link  areaele on elearea.xj_area_id = areaele.xj_area_id
left join bus_eleinfo ele on areaele.ele_id = ele.ele_id
group by elearea.xj_area_id,elearea.xj_area_name) A
left join (select elearea.xj_area_id,elearea.xj_area_name,wm_concat(person.person_name) personname from  bus_elearea_info  elearea
left join bus_xjarea_person_link areaperson on  areaperson.xj_area_id = elearea.xj_area_id
left join sys_person person on areaperson.person_id = person.person_id
group by elearea.xj_area_id,elearea.xj_area_name ) B on A.xj_area_id = B.xj_area_id
阅读更多
版权声明:本文为博主原创文章,未经博主允许不得转载。 https://blog.csdn.net/zxaini2010/article/details/53995647
个人分类: oracle
想对作者说点什么? 我来说一句

没有更多推荐了,返回首页

不良信息举报

分组字符合并

最多只允许输入30个字

加入CSDN,享受更精准的内容推荐,与500万程序员共同成长!
关闭
关闭