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
Oracle主表列表上显示从表字段拼成的字符串,布布扣,bubuko.com
原文：http://www.cnblogs.com/winkey4986/p/3820194.html