SQL Server: Equi Join

 SQL Server     sbo     Updated on Nov 18, 2013     VIKRAM     592   

Introduction:

In this article i will explain what is Equi Join in SQL Server.

Description:

In previous articles i explained what are joins, what is INNER JOIN in SQL Server, what is LEFT JOIN (or) LEFT OUTER JOIN in SQL Server,  what is RIGHT JOIN (or) RIGHT OUTER JOIN, what is FULL JOIN or FULL OUTER JOIN, and what is CROSS JOIN in SQL Server. Now i will explain what is Equi Join in SQL Server.

EQUI JOIN:

One column of first table can be mapped with a column of another table, such thing is called Equi Join.

Syntax:

select       *
from         Employee, Department
where        Employee.DepartmentID = Department.DepartmentID

(or)

select       *
from         Employee as E, Department as D
where        E.DepartmentID = D.DepartmentID

Note:

Equi Join and Inner Join are also same. Only the syntax differs.

  Related Articles
SQL Server: Non Equi Join
SQL Server: Cross Joins
SQL Server: Full Join (or) Full Outer Join
SQL Server: Joins
SQL Server: Right Join (or) Right Outer Join
SQL Server: Left Join (or) Left Outer Join
SQL Server: Inner Join (or) Join
SQL Server: How to get current week dates
SQL Server: Joins - Cartesian Product
  Recent Articles
SQL Server: Non Equi Join
SQL Server: Cross Joins
SQL Server: Full Join (or) Full Outer Join
SQL Server: Joins
SQL Server: Right Join (or) Right Outer Join
SQL Server: Left Join (or) Left Outer Join
SQL Server: Inner Join (or) Join
SQL Server: How to get current week dates
SQL Server: Joins - Cartesian Product