aspdotnet-suresh offers articles and tutorials,csharp dot net, articles and tutorials,VB.NET Articles,Gridview articles,code examples of 2.0 /3.5,AJAX,SQL Server Articles,examples of .net technologies

SQL Server- Difference Between Full Outer Join and Cross Join

Sep 22, 2012

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.

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

If you enjoyed this post, please support the blog below. It's FREE!

Get the latest,, VB.NET, jQuery, Plugins & Code Snippets for FREE by subscribing to our Facebook, Twitter, RSS feed, or by email.

subscribe by rss Subscribe by RSS subscribe by email Subscribe by Email


Pixxel digital india said...

nice websites for development tricks

Nikunj Kumar said...

very much help full. only a single question was not found on this site out of my 250 questions.
means 249/300. i am giving 51 marks to that question.

Give your Valuable Comments

Note: Only a member of this blog may post a comment.

© 2015 All Rights Reserved.
The content is copyrighted to Suresh Dasari and may not be reproduced on other websites without permission from the owner.