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本文共 273 字，大约阅读时间需要 1 分钟。
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