LEFT JOIN
Learn LEFT JOIN (Joins, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.
Introduction A LEFT JOIN (LEFT OUTER JOIN) keeps every row of the left table; when no right row matches, the right-side columns are filled with NULL.