Index: openacs-4/packages/dotlrn-ecommerce/www/applications.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-ecommerce/www/applications.tcl,v
diff -u -r1.34 -r1.35
--- openacs-4/packages/dotlrn-ecommerce/www/applications.tcl	7 Sep 2005 04:42:44 -0000	1.34
+++ openacs-4/packages/dotlrn-ecommerce/www/applications.tcl	7 Sep 2005 21:38:29 -0000	1.35
@@ -260,7 +260,11 @@
 				    from ec_addresses
 				    group by user_id)) e
     on (r.user_id = e.user_id)
-    left join dotlrn_ecommerce_application_assessment_map m
+    left join (select *
+	       from dotlrn_ecommerce_application_assessment_map
+	       where session_id in (select max(session_id)
+				    from dotlrn_ecommerce_application_assessment_map
+				    group by rel_id)) m
     on (r.rel_id = m.rel_id), dotlrn_ecommerce_section s, dotlrn_catalogi t, cr_items i, acs_objects o
 
     where r.community_id = s.community_id