Tutorial 5, page 6 Context: jobsEngine: oracle
Using the view created in question 5 (and NOT the DEPARTMENT table) list the surname and forenames of all employees against the department name they work in. If an employee's department does not exist in the view then show the department name as a blank. Use an OUTER JOIN.
Active SQL index Previous Question Next Question

SQL To Be Executed