Natural Join

Natural join compares all the common columns.

Ex:     SQL> select empno,ename,job,dname,loc from emp natural join dept;