cramerz logo

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


all rights reseverd by Cramerz.com©. web development by web design company DotPeak. hosting by HostBay
all contents on cramerz are the property of Cramerz.com. web design courses