FULL JOIN

Also written: FULL OUTER JOIN

Keeps unmatched rows from both tables, with NULLs where there's no partner. It is useful for comparing two lists.