CROSS JOIN
This will gives the cross
product.
Ex:
SQL> select
empno,ename,job,dname,loc from emp cross join dept;
|
EMPNO
|
ENAME
|
JOB
|
DNAME
|
LOC
|
|
111
|
saketh
|
analyst
|
INVENTORY
|
HYBD
|
|
222
|
sudha
|
clerk
|
INVENTORY
|
HYBD
|
|
333
|
jagan
|
manager
|
INVENTORY
|
HYBD
|
|
444
|
madhu
|
engineer
|
INVENTORY
|
HYBD
|
|
111
|
saketh
|
analyst
|
FINANCE
|
BGLR
|
|
222
|
sudha
|
clerk
|
FINANCE
|
BGLR
|
|
333
|
jagan
|
manager
|
FINANCE
|
BGLR
|
|
444
|
madhu
|
engineer
|
FINANCE
|
BGLR
|
|
111
|
saketh
|
analyst
|
HR
|
MUMBAI
|
|
222
|
sudha
|
clerk
|
HR
|
MUMBAI
|
|
333
|
jagan
|
manager
|
HR
|
MUMBAI
|
|
444
|
madhu
|
engineer
|
HR
|
MUMBAI
|