Index: openacs-4/packages/ecommerce/www/process-order-quantity-shipping.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/process-order-quantity-shipping.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/ecommerce/www/process-order-quantity-shipping.xql	10 Jul 2001 20:42:02 -0000	1.1
+++ openacs-4/packages/ecommerce/www/process-order-quantity-shipping.xql	11 Jul 2001 04:52:05 -0000	1.2
@@ -76,12 +76,14 @@
  
 <fullquery name="get_items_in_cart">      
       <querytext>
-      FIX ME OUTER JOIN
+
 select i.item_id, i.product_id, u.offer_code
-from ec_items i,
+from ec_items i
+    LEFT JOIN
 (select * from ec_user_session_offer_codes usoc where usoc.user_session_id=:user_session_id) u
-where i.product_id=u.product_id(+)
-and i.order_id=:order_id
+	on (i.product_id=u.product_id)
+where i.order_id=:order_id
+
       </querytext>
 </fullquery>