By using joins, you can retrieve data from two or more tables based on logical relationships between the tables. Joins indicate how Microsoft SQL Server should use data from one table to select the rows in another table.

Types of Join:
  • 1.     Inner join

  • 2.     Equi-join

  • 3.     Cross join

  • 4.     Outer joins

  • a.     Leftouter join

  • b.     Rightouter joins

  • c.     Full outer join

  • 5.     Self-join

Please check the following link for detailed description.. 
  Modified On Sep-18-2014 01:23:54 PM

Leave Comment