There are multiple ways to create Cartesian product of two tables in MySQL. Describe them.

Q. There are multiple ways to create Cartesian product of two tables in MySQL. Describe them.

Answer :-

There are following ways to create Cartesian product:-

i = Select * from <Table 1> CROSS JOIN <Table 2> ;
ii = Select * from <Table 1 > , <Table 2> ;