Left Outer Join is same as inner join but LEFT [OUTER] JOIN keyword is use to select records that have matching values in both or among tables where returns all rows from the left (first) table specified in the ON condition and only those rows from the right (second) table where the join condition is met. It also called LEFT Join.
Syntax
SELECT column_list
FROM table1
LEFT [OUTER] JOIN table2
ON (conditions);
Let’s examine the statement above in detail:
- First, specify the main table in the FROM clause, table1 in this case.
- Second, specify the joined table in the LEFT JOIN clause followed by a conditions. The joined table is Table2 in the above statement.
- Third, It returns all rows from multiple tables where the join condition is met.
