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.1 -r1.2 --- openacs-4/packages/assessment/www/sessions.xql 21 Sep 2004 08:55:00 -0000 1.1 +++ openacs-4/packages/assessment/www/sessions.xql 21 Sep 2004 11:52:50 -0000 1.2 @@ -6,8 +6,8 @@ SELECT as_sessionsx.session_id, as_sessionsx.name, as_sessionsx.title, persons.first_names, persons.last_name - FROM as_sessions - WHERE as_sessionsx.assessment_id=:assessment_id AND as_sessions.subject_id = persons.person_id + FROM as_sessionsx INNER JOIN persons ON as_sessionsx.subject_id = persons.person_id + WHERE as_sessionsx.assessment_id=:assessment_id