Is it required that the Join condition be based on equality?

1.	Is it required that the Join condition be based on equality?
Answer» No, joins can have non-equi conditions as well. Join clauses can be used with common comparison operators, such as <, <=, >, >=, !=, BETWEEN. For example, listing records, listing unique pairs, and identifying duplicate records are just a few situations where non-equi joins can prove to be useful.

Discussion