Index: openacs-4/packages/dotlrn/sql/postgresql/dotlrn-community-memberships-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/sql/postgresql/Attic/dotlrn-community-memberships-create.sql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/dotlrn/sql/postgresql/dotlrn-community-memberships-create.sql	29 Mar 2002 19:14:44 -0000	1.2
+++ openacs-4/packages/dotlrn/sql/postgresql/dotlrn-community-memberships-create.sql	21 May 2002 07:46:02 -0000	1.3
@@ -46,11 +46,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,
            dotlrn_member_rels.portal_id,
            membership_rels.member_state
     from dotlrn_member_rels,