In SQL this type of JOIN returns all the rows from the LEFT table and the corresponding matching rows from the right table. If right table doesn’t have the matching record then for such records right table column will have NULL value in the result.

In SQL this type of JOIN returns all the rows from the LEFT table and the corresponding matching rows from the right table. If right table doesn’t have the matching record then for such records right table column will have NULL value in the result.

• NATURAL LEFT
• LEFT [OUTER]
• RECURSIVE HASH
• [FAR] RIGHT 

EXPLANATION

The LEFT JOIN clause allows you to query data from multiple tables. It returns all rows from the left table and the matching rows from the right table. If no matching rows found in the right table, NULL are used.

This means that a left outer join returns all the values from the left table, plus matched values from the Right table or returns NULL in case of no matching join condition satisfied. In Right Outer-Join retrieves the unmatched rows and matched from the Right table and only matched rows from Left table.