FULL OUTER JOIN

LEFT JOIN preserves all rows from the left table. RIGHT JOIN preserves all rows from the right table. FULL OUTER JOIN preserves all rows from both tables. When a row on either side has no match, the columns from the other side are filled with NULLs.