What is Equi Join in SQL Server?


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


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


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


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