Index: openacs-4/packages/assessment/lib/session-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/lib/session-postgresql.xql,v
diff -u -N -r1.2 -r1.3
--- openacs-4/packages/assessment/lib/session-postgresql.xql	26 Sep 2006 04:08:36 -0000	1.2
+++ openacs-4/packages/assessment/lib/session-postgresql.xql	21 Nov 2006 15:13:30 -0000	1.3
@@ -19,7 +19,7 @@
         acs_objects o,
         cr_revisions cr
 	where s.subject_id=:user_id
-	and s.assessment_id=(select latest_revision from cr_items where item_id=:assessment_id)
+        and s.assessment_id in (select revision_id from cr_revisions where item_id= :assessment_id)
 	and o.object_id = cr.item_id
         and s.session_id = cr.revision_id
 	group by assessment_id, subject_id, session_id