Informatics Practices

How is equi-join different from non-equi-join?

SQL Joins & Grouping

2 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

1 Like


Related Questions