Suggest an editImprove this articleRefine the answer for “What does CROSS JOIN do?”. Your changes go to moderation before they’re published.Approval requiredContentWhat you’re changing🇺🇸EN🇺🇦UAPreviewTitle (EN)Short answer (EN)`CROSS JOIN` produces a **cartesian product** of two tables - that is, **every row from the first table gets paired with every row from the second**; it doesn't need an `ON` condition, and the number of result rows equals the product of both tables' row counts. **Key point:** if `colors` has 3 rows and `sizes` has 4, the result is **12 rows** (3 × 4).Shown above the full answer for quick recall.Answer (EN)Image`CROSS JOIN` produces a **cartesian product** of two tables - that is, **every row from the first table gets paired with every row from the second**. It doesn't need an `ON` condition. The number of result rows = the row count of the first table × the row count of the second. ### Example ```sql SELECT * FROM colors CROSS JOIN sizes; ``` If `colors` has 3 rows and `sizes` has 4, the result is **12 rows** (3 × 4).For the reviewerNote to the moderator (optional)Visible only to the moderator. Helps review go faster.