Index: openacs-4/packages/dotlrn-ecommerce/www/admin/process-purchase-all.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-ecommerce/www/admin/process-purchase-all.tcl,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/dotlrn-ecommerce/www/admin/process-purchase-all.tcl	19 Jun 2005 06:05:07 -0000	1.2
+++ openacs-4/packages/dotlrn-ecommerce/www/admin/process-purchase-all.tcl	6 Jul 2005 16:51:08 -0000	1.3
@@ -48,7 +48,12 @@
     set page_query [subst {
 	select u.user_id, u.email, u.first_names, u.last_name, a.phone, a.line1, a.line2
 	from dotlrn_users u
-	left join ec_addresses a
+	left join (select *
+		   from ec_addresses
+		   where address_id
+		   in (select max(address_id)
+		       from ec_addresses
+		       group by user_id)) a
 	on (u.user_id = a.user_id)
 	where (lower(first_names) like lower(:search)||'%' or
 	       lower(last_name) like lower(:search)||'%' or
@@ -109,4 +114,4 @@
     }
 }
 
-set next_url [export_vars -base process-purchase-course { { referer $return_url } section_id }]
\ No newline at end of file
+set next_url [export_vars -base process-purchase-course { { referer $return_url } section_id }]