{"id":94,"date":"2014-05-10T09:22:00","date_gmt":"2014-05-10T08:22:00","guid":{"rendered":"https:\/\/debuggersspace.com\/index.php\/2014\/05\/10\/what-is-cross-join-in-sql-server\/"},"modified":"2014-05-10T09:22:00","modified_gmt":"2014-05-10T08:22:00","slug":"what-is-cross-join-in-sql-server","status":"publish","type":"post","link":"https:\/\/debuggersspace.com\/index.php\/2014\/05\/10\/what-is-cross-join-in-sql-server\/","title":{"rendered":"What is cross Join in SQL Server?"},"content":{"rendered":"
\n
\n \t<\/i> Read Time:<\/span>1 Minute, 10 Second <\/div>\n\n <\/div>
\n
\n
\n
\nIn SQL, the CROSS JOIN<\/span> is used to combine each row of the first table with each row of the second table. It is also known as the Cartesian join since it returns the Cartesian product of the sets of rows from the joined tables.<\/span><\/div>\n<\/div>\n
\n
\nA cross join is used when you wish to create combination of every row from two tables.  All row combinations are included in the result; this is commonly called cross product join.  A common use for a cross join is to create obtain all combinations of items.<\/span><\/div>\n

<\/span><\/div>\n
Example- <\/span><\/div>\n

<\/span><\/div>\n
Suppose that we are sitting in a coffee shop and we decide to order breakfast. Shortly, we will look at the menu and we will start thinking of which meal and drink combination could be more tastier. Our brain will receive this signal and begin to generate all meal and drink combinations.<\/span><\/span><\/div>\n

<\/span><\/span><\/div>\n
<\/p>\n
\"\"<\/a><\/div>\n

<\/span><\/span><\/div>\n<\/div>\n

\n
\nUnlike the INNER JOIN<\/a><\/code> or LEFT JOIN<\/a><\/code>, the cross join does not establish a relationship between the joined tables.<\/span><\/div>\n<\/div>\n
\nSELECT *<\/span><\/span><\/div>\n
\nFROM   t1<\/div>\n
\n       CROSS JOIN t2<\/div>\n<\/span><\/span><\/pre>\n
\n
\nSuppose you wanted to return a report showing every combination of color and size as shown in our sample data below:<\/span><\/div>\n<\/div>\n
\n
\n\"Cross<\/span><\/div>\n
\n
<\/span><\/div>\n<\/div>\n
\n
\nSource – <\/span>https:\/\/www.essentialsql.com\/cross-join-introduction\/<\/a><\/span><\/div>\n

\nRefer – https:\/\/www.educative.io\/edpresso\/what-is-the-sql-cross-join<\/a><\/span><\/div>\n

<\/span><\/div>\n
for run time example-<\/span><\/div>\n
https:\/\/www.sqlshack.com\/sql-cross-join-with-examples\/<\/span><\/a><\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
In SQL, the CROSS JOIN is used to combine each row of the first table with each row of the second table. It is also known as the Cartesian join since it returns the Cartesian product of the sets of rows from the joined tables. A cross join is used when you wish to create combination of […]<\/p>\n","protected":false},"author":43,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","footnotes":""},"categories":[34,38,27],"tags":[],"class_list":["post-94","post","type-post","status-publish","format-standard","hentry","category-ibm","category-sakon","category-sql"],"uagb_featured_image_src":{"full":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false},"uagb_author_info":{"display_name":"Himanshu Namdeo","author_link":"https:\/\/debuggersspace.com\/author\/admin\/"},"uagb_comment_info":0,"uagb_excerpt":"In SQL, the CROSS JOIN is used to combine each row of the first table with each row of the second table. It is also known as the Cartesian join since it returns the Cartesian product of the sets of rows from the joined tables. A cross join is used when you wish to create combination of…","_links":{"self":[{"href":"https:\/\/debuggersspace.com\/index.php\/wp-json\/wp\/v2\/posts\/94"}],"collection":[{"href":"https:\/\/debuggersspace.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/debuggersspace.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/debuggersspace.com\/index.php\/wp-json\/wp\/v2\/users\/43"}],"replies":[{"embeddable":true,"href":"https:\/\/debuggersspace.com\/index.php\/wp-json\/wp\/v2\/comments?post=94"}],"version-history":[{"count":0,"href":"https:\/\/debuggersspace.com\/index.php\/wp-json\/wp\/v2\/posts\/94\/revisions"}],"wp:attachment":[{"href":"https:\/\/debuggersspace.com\/index.php\/wp-json\/wp\/v2\/media?parent=94"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/debuggersspace.com\/index.php\/wp-json\/wp\/v2\/categories?post=94"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/debuggersspace.com\/index.php\/wp-json\/wp\/v2\/tags?post=94"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}