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.
BASIC SYNTAX FOR LEFT JOIN:
FROM table1
LEFTJOIN table2
ON table1.column_field = table2.column_field;