What is Equi Join in SQL Server?

 Updated on October 28, 2014     VIKRAM     563

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.

If you enjoyed this post, please like (or) share this article.


Comments