Database · Easy
What is a CROSS JOIN? When is a Cartesian product intentional vs a bug?
DatabaseSQLFresher
Answer preview
A CROSS JOIN pairs every row of the left table with every row of the right table, producing a Cartesian product of m × n rows. It has no ON clause — an accidental Cartesian product (a missing join condition) is one of the most common causes of a runaway query.…