{"id":3957,"date":"2025-06-07T08:15:40","date_gmt":"2025-06-07T08:15:40","guid":{"rendered":"https:\/\/w3buddy.com\/?post_type=cposts&p=3957"},"modified":"2026-09-26T13:14:42","modified_gmt":"2026-09-26T07:44:42","slug":"sql-cross-join","status":"publish","type":"post","link":"https:\/\/w3buddy.com\/blog\/sql-cross-join\/","title":{"rendered":"SQL CROSS JOIN"},"content":{"rendered":"\n

A CROSS JOIN<\/strong> returns every possible combination<\/strong> of rows from two tables.
It\u2019s called a Cartesian product<\/strong> \u2013 no ON<\/code> clause is required.<\/p>\n\n\n\n

\ud83d\udd39 Basic Syntax<\/h2>\n\n\n\n
SELECT *\nFROM table1\nCROSS JOIN table2;<\/code><\/code><\/pre>\n\n\n\n
\ud83d\udd39 Example: All Product and Region Combinations<\/h2>\n\n\n\n
SELECT\n  p.product_name,\n  r.region_name\nFROM products p\nCROSS JOIN regions r;<\/code><\/code><\/pre>\n\n\n\n
\u2705 If there are 5 products and 3 regions, you get 5 \u00d7 3 = 15 rows<\/strong> \u2013 every combination.<\/p>\n\n\n\n
\ud83d\udd39 Use Cases<\/h2>\n\n\n\n
    \n
  • Generate all combinations (e.g., size \u00d7 color)<\/li>\n\n\n\n
  • Testing and simulations<\/li>\n\n\n\n
  • Matrix-style reports<\/li>\n<\/ul>\n\n\n\n
    \u26a0\ufe0f Caution<\/h2>\n\n\n\n
    CROSS JOIN can return very large results<\/strong> if the tables are big. Use it carefully.<\/p>\n\n\n\n
    \ud83e\udde0 Quick Recap<\/h2>\n\n\n\n
    Key Point<\/th>Explanation<\/th><\/tr><\/thead>
    CROSS JOIN<\/code><\/td>Returns all combinations of rows from both tables<\/td><\/tr>
    Output size<\/td>Multiplies row counts (rows_A \u00d7 rows_B)<\/td><\/tr>
    No ON<\/code> clause<\/td>Doesn\u2019t need a join condition<\/td><\/tr>
    Use cases<\/td>All pairings, simulations, exhaustive comparisons<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
    \ud83d\udca1 Use CROSS JOIN<\/code> when you need every combination of two sets<\/strong>
    <\/p>\n","protected":false},"excerpt":{"rendered":"
    A CROSS JOIN returns every possible combination of rows from two tables.It\u2019s called a Cartesian product \u2013 no ON clause is required. \ud83d\udd39 Basic Syntax \ud83d\udd39 Example: All Product and Region Combinations \u2705 If there are 5 products and 3 regions, you get 5 \u00d7 3 = 15 rows \u2013 every combination. \ud83d\udd39 Use Cases […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"googlesitekit_rrm_CAowu461DA:productID":"","footnotes":""},"categories":[1225,979],"tags":[],"class_list":["post-3957","post","type-post","status-publish","format-standard","hentry","category-database","category-sql"],"_links":{"self":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/posts\/3957","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/comments?post=3957"}],"version-history":[{"count":2,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/posts\/3957\/revisions"}],"predecessor-version":[{"id":4046,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/posts\/3957\/revisions\/4046"}],"wp:attachment":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/media?parent=3957"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/categories?post=3957"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/tags?post=3957"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}