Skip to main content

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.

More lessons in Joins