I am working on SQL Server 2008, and wanted to know about what is the differnce between Cartesian Product and Cross Join. Can somebody please help me to clear the concept?
5 Answers
Cartesian product does not have any condition and result set have total row as r=r1*r2 where r1 rows in first relation and r2 in second relation. joins satisfy specific conditions
when we do a cartesian product of two tables we don't need to find any kinda matched column. But in Join one column must have to be matched from both tables.
Related