Nonequi join

An nonequi (or theta) join is a join statement that uses an unequal operation (i.e: <>, >, <, !=, BETWEEN, etc.) to match rows from different tables. The converse of an nonequi join is a equi join operation.

Examples

Using Oracle join syntax:

SELECT e.ename, e.sal, s.grade
  FROM emp e, salgrade s
 WHERE e.sal BETWEEN s.losal and s.hisal;

Using ANSI join syntax:

SELECT e.ename, e.sal, s.grade
  FROM emp e INNER JOIN salgrade s
    ON e.sal BETWEEN s.losal and s.hisal;

Also see

• Cartesian join
• Equi join
• Inner join
• Natural join
• Outer join
• Self join

Glossary of Terms
A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	#