Glossary term
What is left join? Meaning for developers
Keeps every row of the left table, with NULLs where the right table has no match.
Learn it properly · SQL & PostgreSQLLesson 1: Joins: Combining TablesPrimary and foreign keys, inner, left, right, full and cross joins with drawn result tables, self joins and the NULL trap in left joins.