The LEFT JOIN keyword returns all records from the left table (table1), and the matching records (if any) from the right table (table2).
LEFT JOIN Syntax
SELECT column_name(s)
FROM table1
LEFT JOIN table2
ON table1.column_name = table2.column_name;
FROM table1
LEFT JOIN table2
ON table1.column_name = table2.column_name;
Practice Excercise Practice now