Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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
Add Comment
Please, Sign In to add comment