Home > DeveloperSection > Blogs > Inner Join in Sql Server

Inner Join in Sql Server

Database Database 
1 Comment(s)
 2421  View(s)
Rate this:

Inner  Join in Sql Server

“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 difference it display the duplicate records. So we used the distinct keyword if we do not find the duplicate record.

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 b

where a.Stu_ID =b.Stu_ID and a.AdmissionDate>='2010-07-20'

Inner Join in Sql Server

By Awadhendra Tiwari on   6 years ago

Good example.


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

Follow MindStick