oracle8.1.6 and resolved_date is null select l.*, p.first_names || ' ' || p.last_name as user_name from ec_problems_log l, persons p where l.resolved_by = p.person_id(+) $sql_clause order by problem_date asc