Index: openacs-4/packages/assessment/www/sessions-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/www/sessions-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/assessment/www/sessions-postgresql.xql	7 Oct 2004 13:29:36 -0000	1.1
+++ openacs-4/packages/assessment/www/sessions-postgresql.xql	7 Oct 2004 14:06:50 -0000	1.2
@@ -8,8 +8,8 @@
 			SELECT s.session_id, s.name, s.title, s.completed_datetime,
 			       p.first_names || ' ' || p.last_name AS subject_name,
 			       a.title AS assessment_name, s.subject_id
-			FROM as_sessionsx s INNER JOIN as_assessmentsx a USING assessment_id
-			INNER JOIN persons p ON s.subject_id = p.person_id
+			FROM as_sessionsx s INNER JOIN as_assessmentsx a USING (assessment_id)
+			INNER JOIN persons p ON (s.subject_id = p.person_id)
 			WHERE s.assessment_id = :assessment_id
 		</querytext>
 	</fullquery>
@@ -19,8 +19,8 @@
 			SELECT s.session_id, s.name, s.title, s.completed_datetime,
 			       p.first_names || ' ' || p.last_name AS subject_name,
 			       a.title AS assessment_name, s.subject_id
-			FROM as_sessionsx s INNER JOIN as_assessmentsx a USING assessment_id
-			INNER JOIN persons p ON s.subject_id = p.person_id
+			FROM as_sessionsx s INNER JOIN as_assessmentsx a USING (assessment_id)
+			INNER JOIN persons p ON (s.subject_id = p.person_id)
 			WHERE s.assessment_id = :assessment_id
 			AND s.subject_id = :subject_id
 		</querytext>