select e.employee_id,to_char('-'),e.job_id,to_char(j.start_date),to_char(j.end_date)
from employees e inner join job_history j on e.employee_id=j.employee_id
union all
select employee_id,last_name,job_id, to_char('-'),to_char('-')
from employees
order by employee_id