Suppose if we have two tables in our database - table1 and table2.
then the CROSS JOIN of the two tables gives the cartesian product of the two tables.
Suppose if we have Employee table containing Employee information and Department table containing Departments.
Then when we implement CROSS JOIN, it will map all the Departments to each Employee and displays the product as below,
Asked In: Many Interviews |