Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in SQL by (55.6k points)

Can anyone explain Equi join in SQL?

1 Answer

0 votes
by (119k points)
edited by

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.

Related questions

0 votes
1 answer
asked May 4, 2023 in SQL by neelimakv (32.1k points)
0 votes
1 answer
asked Apr 23, 2020 in SQL by Sudhir_1997 (55.6k points)
0 votes
1 answer
asked Apr 21, 2020 in SQL by Sudhir_1997 (55.6k points)
0 votes
1 answer
asked Feb 17, 2020 in SQL by anmolj (9k points)
0 votes
1 answer

Browse Categories

...