NATURAL JOIN

=>    It is similar to EQUI JOIN, but join can be performed if it has same column name.

Syntax:
=>    Select <collist> FROM <tablename> NATURAL JOIN <tablename>

Examples:

1. Display employee name and respective dept name ?
=>    Select e.ename, d.dname from emp e NATURAL JOIN dept d;