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
Login Details
Email Address
Password
Register for an account
Main Index Page
Author Home Page
Forgotten your password
About ActiveSQL
Tutorial Documents
Database Notes
Online Notes
Reference Pages
Tutorial Activities
Online SQL
Online Quiz
Discussion Forum
Future Stuff
Online Relational Algebra
News