Cross Join

This will gives the cross product.

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