Full outer join

Suppose that you want to find all employees and all of their projects. You want to see those employees that are not currently in charge of a project as well as any projects that do not have an employee assigned. The following query returns a list of all employees whose names are greater than 'S', along with their assigned project numbers:

SELECT EMPNO, LASTNAME, PROJNO
     FROM CORPDATA.EMPLOYEE FULL OUTER JOIN CORPDATA.PROJECT
           ON EMPNO = RESPEMP
     WHERE LASTNAME > 'S'

Because there are no projects without an assigned employee, the query returns the same rows as a left outer join. Here are the results.