---
title: "What is Join in SQLServer?"  
description: "By using joins, you can retrieve data from two or more tables based on logical relationships between the tables. Joins indicate how Microsoft SQL Serv"  
author: "Uttam Misra"  
published: 2011-02-17  
updated: 2014-09-18  
canonical: https://www.mindstick.com/blog/121/what-is-join-in-sqlserver  
category: "database"  
tags: ["database"]  
reading_time: 1 minute  

---

# What is Join in SQLServer?

By using joins, you can [retrieve data](https://www.mindstick.com/forum/160512/how-to-retrieve-data-from-the-database-in-c-sharp-using-dataadapter) from two or more tables based on logical [relationships](https://www.mindstick.com/blog/11850/how-to-build-stronger-relationships-with-your-employees) between the tables. Joins indicate how Microsoft [SQL Server](https://www.mindstick.com/articles/12999/what-is-table-valued-function-in-sql-server) should use data from [one table](https://www.mindstick.com/forum/538/copy-one-table-to-another-in-sql-server-automatically) to select the rows in another table.\
\

##### Types of Join:

- 1. [Inner join](https://www.mindstick.com/forum/33572/sql-inner-join-keyword)
- 2. Equi-join
- 3. [Cross join](https://www.mindstick.com/interview/1850/what-is-cross-join)
- 4. Outer joins
- a. Leftouter join
- b. Rightouter joins
- c. [Full outer join](https://www.mindstick.com/forum/1216/full-outer-join-on-2-data-tables-with-a-list-of-columns)
- 5. Self-join

\

##### Please check the following link for detailed description..

[https://www.mindstick.com/Articles/450/joins-in-sql-server\](https://www.mindstick.com/Articles/450/joins-in-sql-server)[https://www.mindstick.com/Articles/35/join-in-sql-server](https://www.mindstick.com/Articles/35/join-in-sql-server)\

---

Original Source: https://www.mindstick.com/blog/121/what-is-join-in-sqlserver

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.