LEFT JOIN (or LEFT OUTER JOIN): Returns all rows from the left table and?

matched rows from the right table. If there’s no match, NULL is returned for the right

table.

• Use case: When you want all records from the left table.