Full outer joins combine the effects of the left and right outer joins, returning results for all rows, even if a row lacks a corresponding entry from the other table. In these situations, the missing sections return as NULL. Thus, we can search for the Marketing department, even though it has no employees, as well as Worf, who is still without a department. If we hire someone as Marketing Director, we don't have to modify Table 2 at all.