Index: openacs-4/packages/value-based-shipping/www/admin/rate-edit.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/value-based-shipping/www/admin/rate-edit.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/value-based-shipping/www/admin/rate-edit.xql	21 May 2002 18:35:37 -0000	1.1
+++ openacs-4/packages/value-based-shipping/www/admin/rate-edit.xql	23 May 2002 05:33:48 -0000	1.2
@@ -45,11 +45,10 @@
   
   <fullquery name="get_shipping_rate">      
     <querytext>
-      select l.service_level_description, c.default_name as country, round(r.from_value, 2) as from_value, round(r.to_value, 2) as to_value,  
-	  r.from_zip_code, r.to_zip_code, round(r.shipping_rate, 2) as shipping_rate
-      from vbs_rates r left join countries c on (r.country_iso = c.iso), vbs_service_levels l
-      where r.shipping_rate_id = :shipping_rate_id
-      and r.service_level_id = l.service_level_id
+      select shipping_rate_id, service_level_id, country_iso, round(from_value, 2) as from_value, round(to_value, 2) as to_value, from_zip_code, to_zip_code, 
+      round(shipping_rate, 2) as shipping_rate 
+      from vbs_rates
+      where shipping_rate_id = :shipping_rate_id
     </querytext>
   </fullquery>