NON-EQUI JOIN | Oracle Non-Equi join example

NON-EQUI JOIN

 A Join which contains an operator other than equal to ‘=’ in the joins condition.

Ex:

SQL> select empno,ename,job,dname,loc from emp e,dept d where e.deptno > d.deptno;

EMPNO	ENAME	JOB	DNAME	LOC
222	sudha	clerk	INVENTORY	HYBD
444	madhu	engineer	INVENTORY	HYBD
444	madhu	engineer	FINANCE	BGLR
444	madhu	engineer	HR	MUMBAI