Index: openacs-4/packages/assessment/www/sessions.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/www/Attic/sessions.xql,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/assessment/www/sessions.xql	23 Sep 2004 14:20:56 -0000	1.4
+++ openacs-4/packages/assessment/www/sessions.xql	28 Sep 2004 11:27:13 -0000	1.5
@@ -6,15 +6,15 @@
 	<fullquery name="sessions_of_assessment">
 		<querytext>
 			SELECT as_sessionsx.session_id, as_sessionsx.name, as_sessionsx.title, as_sessionsx.completed_datetime, as_sessionsx.subject_id, persons.first_names || ' ' || persons.last_name AS subject_name, as_assessmentsx.title AS assessment_name
-			FROM (as_sessionsx INNER JOIN as_assessments ON as_sessionsx.assessment_id = as_assessments.assessment_id) INNER JOIN persons ON as_sessionsx.subject_id = persons.person_id
+			FROM (as_sessionsx INNER JOIN as_assessmentsx ON as_sessionsx.assessment_id = as_assessmentsx.assessment_id) INNER JOIN persons ON as_sessionsx.subject_id = persons.person_id
 			WHERE as_sessionsx.assessment_id=:assessment_id
 		</querytext>
 	</fullquery>
 
 	<fullquery name="sessions_of_assessment_of_subject">
 		<querytext>
 			SELECT as_sessionsx.session_id, as_sessionsx.name, as_sessionsx.title, as_sessionsx.completed_datetime, as_sessionsx.subject_id, persons.first_names || ' ' || persons.last_name AS subject_name, as_assessmentsx.title AS assessment_name
-			FROM (as_sessionsx INNER JOIN as_assessments ON as_sessionsx.assessment_id = as_assessments.assessment_id) INNER JOIN persons ON as_sessionsx.subject_id = persons.person_id
+			FROM (as_sessionsx INNER JOIN as_assessmentsx ON as_sessionsx.assessment_id = as_assessmentsx.assessment_id) INNER JOIN persons ON as_sessionsx.subject_id = persons.person_id
 			WHERE as_sessionsx.assessment_id=:assessment_id AND as_sessionsx.subject_id=:subject_id
 		</querytext>
 	</fullquery>