Hello team
Will that create Cartesian product If we join two data sets and the variable join has blanks?
Thanks,
Bitta
Cartesian product
-
- Administrator
- Posts: 78595
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Cartesian product
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.
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
Hans
-
- BronzeLounger
- Posts: 1498
- Joined: 01 Mar 2015, 02:03
Re: Cartesian product
Thanks for the response.
Regards,
Bitten
Regards,
Bitten