CROSS JOIN SQL

What does SQL CROSS JOIN do?

It produces number of rows in  the first table multiplied by the number of rows in the second table - a Cartesian Product.

Syntax 


FROM table1
CROSS JOIN table2;