A FULL JOIN (or FULL OUTER JOIN) returns all rows from both tables when there is a match. If there are no matches, NULL values are returned for the columns from the table with no match.

Example: Using FULL JOIN

SELECT FreedomFighters.Name, Events.EventName
FROM FreedomFighters
FULL JOIN Events ON FreedomFighters.FighterID = Events.FighterID;