Oracle主表列表上显示从表字段拼成的字符串

select t.*,t1.person_names from itil_duty_group t ,(
select p.duty_group_id, WMSYS.WM_CONCAT(p.person_name) person_names From itil_duty_group_person p
where 1=1 GROUP BY p.duty_group_id) t1
where t.id = t1.duty_group_id

【推广】 免费学中医，健康全家人
原文地址：https://www.cnblogs.com/winkey4986/p/3820194.html