oracle 8.1.6 select o.order_state, o.creditcard_id, o.confirmed_date, o.cs_comments, o.shipping_method, o.shipping_address, o.in_basket_date, o.authorized_date, o.shipping_charged, o.voided_by, o.voided_date, o.reason_for_void, u.user_id, u.first_names, u.last_name, c.billing_address from ec_orders o, cc_users u, ec_creditcards c where order_id=:order_id and o.user_id = u.user_id(+) and o.creditcard_id = c.creditcard_id(+)