Why :
"select distinct order_id
from orderAddresses
where order_id NOT IN
(select distinct order_id
from OrderAddresses,ShippingDetails
where OrderAddresses.order_address_id = ShippingDetails.order_address_id
and ShippingDetails.b_shipping_status != 3)"
dont' wark ?
"select distinct order_id
from orderAddresses
where order_id NOT IN
(select distinct order_id
from OrderAddresses,ShippingDetails
where OrderAddresses.order_address_id = ShippingDetails.order_address_id
and ShippingDetails.b_shipping_status != 3)"
dont' wark ?