A left join is an outer join which generates a result that contains all the rows of the left table even when there are no matching rows in other (right side) table taking part in the join.
