Completion requirements
Review this example of an outer join.
Click on SQL OUTER JOIN to open the resource.