VIEW after outer join of Employees and Departments Last^Name First^Name Dept^Name Floor ------------------------------------------- Davis Fred Sales 5 Harris Martha Smith John Engineering 8