SQL Server- Difference Between Full Outer Join and Cross Join

Introduction:

Here I will explain what is the difference between cross join and full outer join in SQL Server.

Description:

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.

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

Left Join, Right Join, Cross Join, Inner Join, Self Join, Full Outer Joins in SQL Server

If you enjoyed this post, please support the blog below. It's FREE! Get the latest Asp.net, C#.net, VB.NET, jQuery, Plugins & Code Snippets for FREE by subscribing to our Facebook, Twitter, RSS feed, or by email.

Subscribe by RSS Subscribe by Email