MySQL LEFT JOIN Keyword

The LEFT JOIN keyword in MySQL is used to return all records from the left table (table1), and the matching records (if any) from the right table (table2). If there is no match, the result will still include all records from the left table, but with NULL values for the columns from the right table.

LEFT JOIN Syntax

SELECT column_name(s)
FROM table1
LEFT JOIN table2
ON table1.column_name = table2.column_name;