Types of SQL server joins with example

This article describes the types of SQL server joins like Inner, Outer, Cross, Equi, Self Joins with examples. You can retrieve data from more than one table together as a part of a single result set.

Types of Joins

1. Inner Join
2. Outer Join
   1. Left outer Join
   2. Right Outer Join
   3. Full Outer Join
3. Cross Join
4. Equi Join
5. Self Join

Following image shows result set of Outer join

For more detailed description visit - SQL Server Joins with Example