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(+)
组映射关系
最新推荐文章于 2022-10-20 22:04:11 发布
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(+)