SQL LEFT JOIN
The SQL left join returns all the values from the left table and it also includes matching values from right table, if there are no matching join value it returns NULL.
SQL Left Join Syntax
SELECT table1.column1, table2.column2.... FROM table1 LEFTJOIN table2 ON table1.column_field = table2.column_field;