Creating Joins with the ON Clause

• The join condition for the natural join is basically an equijoin of all columns with the same name
• Use the ON clause to specify arbitrary conditions or specify columns to join
• The join condition is separated from other search conditions
• The ON clause makes code easy to understand

Retrieving Records with the ON Clause :

• SELECT e.empno, e.ename, e.deptno, d.deptno, d.loc FROM emp e JOIN dept d ON (e.deptno = d.deptno);

•