关闭

分组字符合并

74人阅读 评论(0) 收藏 举报
分类:
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
0
0

查看评论
* 以上用户言论只代表其个人观点,不代表CSDN网站的观点或立场
    个人资料
    • 访问:4026次
    • 积分:152
    • 等级:
    • 排名:千里之外
    • 原创:9篇
    • 转载:17篇
    • 译文:0篇
    • 评论:0条
    文章分类