What are cross joins?

 Posted by Karthikanbarasan on 1/8/2011 | Category: Sql Server Interview questions | Views: 2863 | Points: 40

? A cross join that does not have a WHERE clause produces the Cartesian product of the tables involved in the join.
? The size of a Cartesian product result set is the number of rows in the first table multiplied by the number of rows in the second table.
? Example: is when company wants to combine each product with a pricing table to analyze each product at each price.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response