Pages

Thursday 10 January 2013

Difference Between Full Outer Join and Cross Join

Cross Join:
A cross join that produces Cartesian product of the tables that involved in the join. The size of a Cartesian product is the number of the rows in first table multiplied by the number of rows in the second table.

Full Outer Join:
Full Outer Join displays all the matching and non matching rows of both the tables.
If you want to know in-depth about Joins in SQL Server please check below link in that post I explained each join clearly with examples

No comments:

Post a Comment