Informatics Practices
How is equi-join different from non-equi-join?
SQL Joins & Grouping
3 Likes
Answer
In an equi-join, the values in the columns being joined are compared for equality using the "=" operator, and all columns from the joined tables are included in the result set, even if they are identical. On the other hand, a non-equi-join specifies a relationship other than equality between the columns using operators like <, >, <=, >=, !=, or <>.
Answered By
2 Likes