---
title: "Inner  Join in Sql Server"  
description: "“INNER JOIN retrieves all the records from the left table and all the records from the right table.”  It is similar to intersect operator but basic di"  
author: "Amit Singh"  
published: 2011-04-28  
updated: 2014-09-18  
canonical: https://www.mindstick.com/blog/145/inner-join-in-sql-server  
category: "database"  
tags: ["database"]  
reading_time: 1 minute  

---

# Inner  Join in Sql Server

“[INNER JOIN](https://www.mindstick.com/forum/33572/sql-inner-join-keyword) retrieves all the records from the left table and all the records from the right table.”\

It is similar to [intersect](https://www.mindstick.com/forum/34040/use-intersect-in-sql-server) [operator](https://www.mindstick.com/blog/144/union-intersection-and-except-operator-in-sql-server) but [basic difference](https://www.mindstick.com/interview/2438/what-is-the-basic-difference-between-string-and-stringbuffer-object) it display the [duplicate records](https://answers.mindstick.com/qa/116428/how-to-delete-duplicate-records-but-keep-one). So we used the [distinct keyword](https://www.mindstick.com/forum/160083/what-is-the-sql-distinct-keyword-and-when-it-used-in-a-search-query) if we do not find the duplicate record.

##### Example:

##### ANSI Style:

```
select a.Stu_ID,a.Stu_Name from tbl_SchoolRecord a inner join tbl_StudentRecord b on a.Stu_ID =b.Stu_ID where a.AdmissionDate>='2010-07-20'
```

##### Theta style:

```
select a.Stu_ID,a.Stu_Name from tbl_SchoolRecord a, tbl_StudentRecord bwhere a.Stu_ID =b.Stu_ID and a.AdmissionDate>='2010-07-20'
```

###

---

Original Source: https://www.mindstick.com/blog/145/inner-join-in-sql-server

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