cavebatsofware · February 8, 2013 14:02
diff --git a/update_shipping_method.sql b/update_shipping_method.sql
 update order_details
 set shipment_method_id = 'i2U12R'
 where order_id in 
    (
        select 
            order_id
        from
            orders
        where
            client_id = 'artkohlcom' and status <> 'Shipped' and status <> 'Cancelled'
    )
	update order_details
	set shipment_method_id = 'i2U12R'
	where order_id in
	(
	select
	order_id
	from
	orders
	where
	client_id = 'artkohlcom' and status <> 'Shipped' and status <> 'Cancelled'
	)