SQL Server: Equi Join

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.