What is the result of a CROSS JOIN between two tables?

Study for the SQL Basics Test. Improve your knowledge with multiple choice questions and detailed explanations. Prepare effectively to master SQL concepts!

Multiple Choice

What is the result of a CROSS JOIN between two tables?

A CROSS JOIN produces the Cartesian product of the two tables: every row from the first table paired with every row from the second. If the first table has m rows and the second has n rows, the result will have m × n rows, with each resulting row containing columns from both tables. There is no matching condition required, which is why it differs from inner joins that only include rows where a condition is met. It also isn’t simply a union of the two tables, nor a set of rows with common values—that behavior comes from other operations or joins.

A CROSS JOIN produces the Cartesian product of the two tables: every row from the first table paired with every row from the second. If the first table has m rows and the second has n rows, the result will have m × n rows, with each resulting row containing columns from both tables. There is no matching condition required, which is why it differs from inner joins that only include rows where a condition is met. It also isn’t simply a union of the two tables, nor a set of rows with common values—that behavior comes from other operations or joins.

More practice questions