Write Select Statement Creates Left Outer Join Remember Left Outer Join Returns Unmatched Q37024867

1. Write a SELECT statement that creates a left outer join(remember that a left outer join returns unmatched rows).

The result set has department_name,department_number and last_name.

Order this by department_name.

.

2. Write a SELECT statement – right outer join- to join theDepartments and the Employees table. All of the rows from theEmployees table are included in the result set. This will returnsome null values.

Solution

1).

SELECT dept.department_name, dept.department_number,emp.last_name FROM Departments dept LEFT OUTER JOIN Employees empON Employees.department_id = Departments.department_id ORDER BYdept.department_name

2).

SELECT dept.department_name, dept.department_number,emp.last_name FROM Departments dept RIGHT OUTER JOIN Employees empON Employees.department_id = Departments.department_id.

Please comment if you need any help.