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 (or) 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.
If you enjoyed this post, please like (or) share this article.