Equi join

An equi join (aka. inner join or simple join) is a join statement that uses an equivalence operation (i.e: colA = colB) to match rows from different tables. The converse of an equi join is a nonequi join operation.

Examples

Using Oracle join syntax:

SELECT ename, job, dept.deptno, dname
  FROM emp, dept
 WHERE emp.deptno = dept.deptno;

SELECT *
  FROM emp, dept
 WHERE emp.deptno = dept.deptno
   AND job = 'CLERK';

Using ANSI join syntax:

SELECT ename, dname
 FROM emp INNER JOIN dept
   ON emp.deptno = dept.deptno

Also see

• Cartesian join
• Inner join
• Natural join
• Nonequi 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	#