-
Junior Member
Joins
Dear Team,
Cartesian join is not clear to me.Would you pls explain that cartesian product is all combination of rows from different tables.When do we apply cartesian join and where is it useful?
-
Expert Member
Re: Joins
Catersian Product is obtained when you give invalid join condition or ommit join condition. It joins every row of one table with every row of another table. For example if table x with 10 rows joined with table y with 10 rows , a cartesian join will return 100 rows. It is rarely used. Give proper join condition to avoid catesian join.
Last edited by krishnaindia2007; 07-01-2008 at 10:18 PM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules