SQL Equijoin:
The join condition determines whether the join is an equijoin or a non equijoin. when we relate two tables on a join condition by equating the columns from the tables, it is an equijoin. when we relate two tables on a join condition by an operator other than equality it is an non-equijoin. A query may contain equijoins as well as non-equijoins.
Examples of Equijoin:
Select emp.deptno, bonus.comm
from emp bonus
where emp.ename = bonus.ename
SELECT * FROM emp
INNER JOIN dept
ON emp.DeptID = dept.DeptID
