Here I will explain what is the difference between cross join and full outer join in SQL Server.
In previous posts I explained difference between Left Join and Left Outer Join, difference between ExecuteNonQuery, ExecuteReader, ExecuteScalar, Difference between Len and DataLength and many articles relating to SQL Server. Now I will explain the difference between cross join and full outer join in SQL Server.
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