Index: openacs-4/packages/dotlrn/sql/oracle/community-memberships-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/sql/oracle/community-memberships-create.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/dotlrn/sql/oracle/community-memberships-create.sql	6 May 2002 23:55:01 -0000	1.1
+++ openacs-4/packages/dotlrn/sql/oracle/community-memberships-create.sql	21 May 2002 07:46:02 -0000	1.2
@@ -39,11 +39,9 @@
            acs_rels.object_id_one as community_id,
            acs_rels.object_id_two as user_id,
            acs_rels.rel_type,
-           (select acs_rel_roles.pretty_name
-            from acs_rel_roles
-            where acs_rel_roles.role = (select acs_rel_types.role_two
-                                        from acs_rel_types
-                                        where acs_rel_types.rel_type = acs_rels.rel_type)) as role,
+           (select acs_rel_types.role_two
+            from acs_rel_types
+            where acs_rel_types.rel_type = acs_rels.rel_type) as role,
            membership_rels.member_state
     from dotlrn_member_rels,
          acs_rels,
