Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa SQL What is a Cartesian product?
Login         

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


hemant kumar
What is a Cartesian product?
1 Answer(s)      3 years and 11 months ago
Posted in : SQL


What is a Cartesian product?


Advertisement
View Answers

November 19, 2010 at 11:37 AM


Hi,

Here is the answer,

The Cartesian product, also referred to as a cross-join, returns all the rows in all the tables listed in the query. Each row in the first table is paired with all the rows in the second table. This happens when there is no relationship defined between the two tables. Both the EMPLOYEE and STORE tables have 5 rows. If we use a Cartesian join in these two tables, we will get back 25 rows.

Thanks,



Related Tutorials/Questions & Answers:
Advertisements
Advertisements
 

 

 

DMCA.com