oracle8.1.6 select u.email, to_char(confirmed_date,'MM/DD/YY') as confirmed_date, shipping_address, u.user_id from ec_orders, cc_users u where ec_orders.user_id = u.user_id and order_id = :order_id insert into ec_automatic_email_log (user_identification_id, email_template_id, order_id, date_sent) values (:user_identification_id, 1, :order_id, sysdate) insert into ec_automatic_email_log (user_identification_id, email_template_id, order_id, date_sent) values (:user_identification_id, 3, :order_id, sysdate) insert into ec_automatic_email_log (user_identification_id, email_template_id, order_id, date_sent) values (:user_identification_id, 3, :order_id, sysdate) insert into ec_automatic_email_log (user_identification_id, email_template_id, order_id, date_sent) values (:user_identification_id, 3, :order_id, sysdate) insert into ec_automatic_email_log (user_identification_id, email_template_id, order_id, date_sent) values (:user_identification_id, 3, :order_id, sysdate) insert into ec_automatic_email_log (user_identification_id, email_template_id, order_id, date_sent) values (:user_identification_id, 3, :order_id, sysdate)