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.