Tag: What is Cross-Join?

Cross join defines as a Cartesian product where the number of rows in the first table multiplied by the number of rows in the second table. I suppose, WHERE clause is used in cross join then the query will work like an INNER JOIN.