Index: openacs-4/packages/courses/www/cc-admin/course-list.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/courses/www/cc-admin/course-list.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/courses/www/cc-admin/course-list.xql	2 Feb 2005 23:01:00 -0000	1.2
+++ openacs-4/packages/courses/www/cc-admin/course-list.xql	9 Feb 2005 22:54:02 -0000	1.3
@@ -3,10 +3,10 @@
 
 <fullquery name="get_course_info">      
       <querytext>
-            select course_id, course_key, course_name, course_info, assessment_id, item_id
-	    from course_catalog, cr_items
-	    where course_id = live_revision and  
-	    item_id in (
+            select cc.course_id, cc.course_key, cc.course_name, cc.course_info, cc.assessment_id, ci.item_id
+	    from course_catalog cc, cr_items ci
+ 	    where cc.course_id = ci.live_revision and  
+	    ci.item_id in (
 		select object_id from acs_permissions where grantee_id = :user_id and
 		privilege = 'admin')
          	
@@ -15,9 +15,9 @@
 
 <fullquery name="get_course_info_site_wide">      
       <querytext>
-            select course_id, course_key, course_name, course_info, assessment_id 
-	    from course_catalog, cr_items
-	    where course_id = live_revision          	
+            select cc.course_id, cc.course_key, cc.course_name, cc.course_info, cc.assessment_id, ci.item_id
+	    from course_catalog cc, cr_items ci
+ 	    where cc.course_id = ci.live_revision
       </querytext>
 </fullquery>