Cartesian product

BittenApple
BronzeLounger
Posts: 1498
Joined: 01 Mar 2015, 02:03

Cartesian product

Post by BittenApple »

Hello team

Will that create Cartesian product If we join two data sets and the variable join has blanks?

Thanks,

Bitta

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Cartesian product

Post by HansV »

No, you get a Cartesian product if you create a query based on two tables and don't join them at all.
The result will be all possible combinations of a record from the first table with a record of the other table.
If the first table has 20 record and the other one has 35 records, the Cartesian product query will have 20 * 35 = 700 records.
Best wishes,
Hans

BittenApple
BronzeLounger
Posts: 1498
Joined: 01 Mar 2015, 02:03

Re: Cartesian product

Post by BittenApple »

Thanks for the response.
Regards,
Bitten