SQL Tutorials

Tutorial 5, page 6

Context: jobs

Engine: 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