Learn how to use the SQL FULL OUTER JOIN to combine the results of both left and right joins, returning all records when there is a match in either table.