Non-Equi Joins
Non-Equi Joins specify the relationship among the tables not in terms of columns but in terms of the relational operators or any comparison operators used. The subsequent instance deals with this category of join:
Example
SELECT ename,grade FROM emp, salgrade WHERE sal BETWEEN losal AND hisal;
The relationship among the tables emp and salgrade are established using the values and the BETWEEN operator.