Home > DeveloperSection > Blogs > What is Join in SQLServer?

What is Join in SQLServer?

Database Database 
0 Comment(s)
 2077  View(s)
Rate this:

What is Join in SQLServer?

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.. 

Don't want to miss updates? Please click the below button!

Follow MindStick