oracle8.1.6 select g.rel_type, g.group_id, acs_object.name(g.group_id) as group_name, t.pretty_name as rel_pretty_name from acs_object_types t, group_rels g where g.group_rel_id = :group_rel_id and t.object_type = g.rel_type