oracle8.1.6 select i.user_identification_id, i.order_id, i.closed_by, i.deleted_p, i.open_date, i.close_date, to_char(i.open_date,'YYYY-MM-DD HH24:MI:SS') as full_open_date, to_char(i.close_date,'YYYY-MM-DD HH24:MI:SS') as full_close_date, u.first_names || ' ' || u.last_name as closed_rep_name from ec_customer_service_issues i, cc_users u where i.closed_by=u.user_id(+) and issue_id=:issue_id select a.action_id, a.interaction_id, a.action_details, a.follow_up_required, i.customer_service_rep, i.interaction_date, to_char(i.interaction_date,'YYYY-MM-DD HH24:MI:SS') as full_interaction_date, i.interaction_originator, i.interaction_type, m.info_used from ec_customer_service_actions a, ec_customer_serv_interactions i, ec_cs_action_info_used_map m where a.interaction_id=i.interaction_id and a.action_id=m.action_id(+) and a.issue_id=:issue_id order by a.action_id desc