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?
Printable View
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?
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.