You can define join indexes using inequality conditions.
To define inequality conditions between 2 columns of the same type, from the same table or from two different tables, you must AND the inequality conditions with the other join conditions.
This enables the Optimizer to resolve a request using a join index more frequently than otherwise possible, avoiding the need to access base data tables to retrieve the required data.