Define an equi-join. What is non-equi-join ?

The join, in which columns are compared for equality, is called equi-join. The comparison operator used is "=".

A non-equi-join is a query that specifies some relationship other than equality between the columns. The comparison operators used are '<>', '<', '>', '<=', and '>='.