sql 多行数据合并
2017-06-07 15:21 xiangjune 阅读(354) 评论(0) 编辑 收藏 举报SELECT a.roleid,
string_agg(b.orgname, ',') orgname
FROM t_con_role_org a,
t_e_org_edu b
WHERE a.orgeduid = b.orgid
GROUP BY a.roleid