Skip to content

Latest commit

 

History

History
21 lines (14 loc) · 683 Bytes

README.md

File metadata and controls

21 lines (14 loc) · 683 Bytes

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

SQL Server Outer Joins

For more detailed description visit - SQL Server Joins with Example