What is “CROSS JOIN”? OR What is Cartesian product?

 Posted by ArticlesMaint on 10/3/2009 | Category: Sql Server Interview questions | Views: 8361

“CROSS JOIN” or “CARTESIAN PRODUCT” combines all rows from both tables. Number of rows will be product of the number of rows in each table. In real life scenario, I cannot imagine where we will want to use a Cartesian product. However, there are scenarios where we would like permutation and combination probably Cartesian would be the easiest way to achieve it.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response