Question

What are some of the differences between an equi-join and an inner join in SQL?

Answer 1

Inner Join :

SELECT * FROM emp_table JOIN dept_table

ON emp_table.DeptID = dept_table.DeptID;

Equi Join

SELECT * FROM emp_table INNER JOIN dept_table USING(DeptID)

Both will give you same outcomes.

The distinction here is for the Inner join I can have an alternate condition ,, for example, "=" , <> , > , < and so on, yet same isn't valid for equi join.

Notes :

Inner join can have fairness (=) and different administrators (like <,>,<>) in the join condition.

Equi join just have fairness (=) administrator in the join condition.

Equi join can be an Inner join, Left External join, Right External join

The Utilizing provision isn't upheld by SQL Worker and Sybase. This statement is upheld by Prophet and MySQL.