oracle 8.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, shipment_id, date_sent) values (:user_identification_id, 2, :order_id, :shipment_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, gift_certificate_id, date_sent) values (:user_identification_id, 4, :gift_certificate_id, sysdate) insert into ec_automatic_email_log (user_identification_id, email_template_id, gift_certificate_id, date_sent) values (:user_identification_id, 5, :gift_certificate_id, sysdate) insert into ec_automatic_email_log (user_identification_id, email_template_id, gift_certificate_id, date_sent) values (:user_identification_id, 6, :gift_certificate_id, sysdate)