LEFT JOIN returns all records from the left table , and the matched records from the right table . if there is no match it will return NULL from right side table.