LEFT JOIN

LEFT JOIN — Returns all rows from the left table and the matched rows from the right table.

LEFT JOIN

SELECT *
FROM table1
LEFT JOIN table2
ON table1.column_name = table2.column_name;