What is Equi join in SQL?

Question

Can anyone explain Equi join in SQL?

Answer 1

Equi join is a join that returns the matching values of both tables using an equality operator. It may sound similar to Inner join. The main difference is, in Equi join we can use only equality (=) operator whereas in Inner join can use all operators (=, <, >).

Here is the syntax to use Equi Join in SQL:

SELECT column1, column2, …

FROM tableA, tableB

WHERE tableA.column_name = tableB.column_name;

Or

SELECT column1, column2,…

FROM tableA

JOIN tableB

[ON (join_condition)]

If you want to learn SQL from top experts, I recommend this SQL certification program by Intellipaat.