what is the difference between inner join and equi join?

[Manjunatht]

i need the answer for this question,in inner join we aren't using where clause in eqi join we are using where clause
can u give me the answer?

[Rabbit]

An equi join is a join which uses only equality comparisons. There is no requirement that an equi join uses the WHERE clause. I don't know where you got that requirement from. Both of the following examples are equi joins.

SELECT *
FROM employee
JOIN department ON 
employee.DepartmentID = department.DepartmentID;

SELECT * 
FROM employee, department 
WHERE employee.DepartmentID = department.DepartmentID;