What is the difference between Cartesian product and cross join?
sql-server
Solution
When you do Cross join you will get cartesian product. Each row in the first table is matched with every row in the second table
Problem
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?