NATURAL JOIN
Natural join compares all the
common columns.
Ex:
SQL> select
empno,ename,job,dname,loc from emp natural join dept;
|
EMPNO
|
ENAME
|
JOB
|
DNAME
|
LOC
|
|
111
|
saketh
|
analyst
|
INVENTORY
|
HYBD
|
|
333
|
jagan
|
manager
|
INVENTORY
|
HYBD
|
|
222
|
sudha
|
clerk
|
FINANCE
|
BGLR
|