A JOIN based on the left table that fills unmatched rows with NULL.
A join that keeps every row from the left table, filling in NULL when there's no matching row in the right table.
© 2026 ITBGM