Cross join:

This join produces the Cartesian product of the two tables.

Example:

Select emp-name, dept-name
From emp
Cross join dept ;

The above example will display the Cartesian product of the two table emp and dept.
The example given below will give the same result as the above.

Example:

Select emp-name, dept-name
From emp, dept ;


  Tutorials

Popular Links

Contact Us

address Plot No-741,2ND Floor
Opp. Bhagabati Temple,Jayadev Vihar
      Bhubaneswar-751013
      Email: info@silantechnology.com
      Phone: 0674-2361252
address
39877, sundale dr, apt#101, Fremont, California 94538, USA
       Phone: +1(262)388-7619

facebook twitter google linked in

© 2018 Silan Technology. All Rights Reserved