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.2 -r1.3
--- openacs-4/packages/assessment/www/sessions-postgresql.xql	7 Oct 2004 14:06:50 -0000	1.2
+++ openacs-4/packages/assessment/www/sessions-postgresql.xql	20 Dec 2004 14:01:46 -0000	1.3
@@ -5,25 +5,13 @@
 
 	<fullquery name="sessions_of_assessment">
 		<querytext>
-			SELECT s.session_id, s.name, s.title, s.completed_datetime,
+			SELECT s.session_id, s.name, s.title, s.completed_datetime, s.percent_score,
 			       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)
 			WHERE s.assessment_id = :assessment_id
-		</querytext>
-	</fullquery>
-
-	<fullquery name="sessions_of_assessment_of_subject">
-		<querytext>
-			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)
-			WHERE s.assessment_id = :assessment_id
 			AND s.subject_id = :subject_id
 		</querytext>
-	</fullquery>
-	
+	</fullquery>	
 </queryset>