- Report the employee_id, the name of the employee, and all his job assignments from table HR_Job_History. Report the start date and job id of each of the employee’s jobs. Write the query in a total of 3 ways:
A. Using equijoins (the older syntax)
hr_employees w, hr_job_history l
where ….
2. Change the query of question 1 to be able to see ALL the employees, including those without previous job assignments. If an employee has no job assignments, then print ’01/01/1900′ and ‘-99’.
Use LEFT OUTER JOIN