A LEFT JOIN (or LEFT OUTER JOIN) returns all rows from the left table and the matching rows from the right table. If there are no matches, NULL values are returned for the columns from the right table.

Example: Using LEFT JOIN

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