Index: openacs-4/packages/dotlrn/sql/oracle/dotlrn-clubs-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/sql/oracle/Attic/dotlrn-clubs-create.sql,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/dotlrn/sql/oracle/dotlrn-clubs-create.sql	17 Dec 2001 23:02:55 -0000	1.4
+++ openacs-4/packages/dotlrn/sql/oracle/dotlrn-clubs-create.sql	13 Mar 2002 00:12:09 -0000	1.5
@@ -31,10 +31,13 @@
            dotlrn_communities.portal_id,
            dotlrn_communities.portal_template_id,
            dotlrn_communities.package_id,
-           dotlrn_community.url(dotlrn_communities.community_id) as url
+           dotlrn_community.url(dotlrn_communities.community_id) as url,
+           groups.join_policy
     from dotlrn_communities,
-         dotlrn_clubs
-    where dotlrn_communities.community_id = dotlrn_clubs.club_id;
+         dotlrn_clubs,
+         groups
+    where dotlrn_communities.community_id = dotlrn_clubs.club_id
+    and dotlrn_communities.community_id = groups.group_id;
 
 create or replace package dotlrn_club
 is