组映射关系

select a.id, b.org_node_name itil_group_name, c.gname trs_group_name
from t_itil_wcm_group a
    ,t_org_node b
   , trsdba.wcmgroup c
where a.itil_id = b.org_node_id(+)
and a.wcm_id = c.groupid(+)