Left Join is used to join two tables and it return all rows from table 1 and matching rows from table 2. The result is NULL for unmatched rows for table 2. Left Join keyword is used to apply Left Join on two tables.
Syntax for Left Join:
LEFT JOIN tablename2
In the above syntax there is a column taken from both table on which left join is applied and this column must be same in both tables.