SQL Outer Join

SQL Outer Join will select all rows from joining tables. If we want to see all items no matter if they are ordered or not, SQL outer join can be useful.

Difference Between Inner and Outer Join

The difference between Inner Join and Outer Join is that Inner join will only select those rows from joining table where a matching record is available. On the other hand Outer Join will select all rows, even if there is no matching records.

Types of Outer Join

Outer Join is sub divided into two types

  • Left Outer Join
  • Right Outer Join