CROSS JOIN

CROSS JOIN

=>    It returns x-product of 2 tables.
=>    Each record of table 1 is combined with each record of table 2.

Syntax:
=>    Select <collist> from <tablelist>
=>    Select <collist> from <table 1> CROSS JOIN <table 2>

Examples:

1. Select e.ename , d.dname from emp e , dept d;
2. Select e.ename, d.dname from emp e CROSS JOIN dept d;