首页 > 代码库 > Oracle主表列表上显示从表字段拼成的字符串

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