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.2 -r1.3
--- openacs-4/packages/assessment/www/sessions.xql	21 Sep 2004 11:52:50 -0000	1.2
+++ openacs-4/packages/assessment/www/sessions.xql	22 Sep 2004 19:36:32 -0000	1.3
@@ -5,8 +5,8 @@
 
 	<fullquery name="sessions_of_assessment">
 		<querytext>
-			SELECT as_sessionsx.session_id, as_sessionsx.name, as_sessionsx.title, persons.first_names, persons.last_name
-			FROM as_sessionsx INNER JOIN persons ON as_sessionsx.subject_id = persons.person_id
+			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
 			WHERE as_sessionsx.assessment_id=:assessment_id
 		</querytext>
 	</fullquery>