oracle8.1.6 select l.*, u.first_names || ' ' || u.last_name as user_name from ec_problems_log l, cc_users u where l.resolved_by = u.user_id(+) $sql_clause order by problem_date asc