Inner Join Vs Outer Join vs Cross Join

Question

Difference between Inner JoinOuter Join and Cross Join in Sql ???

Pranay Rana · Answer

Please check the below image and related article help you to understand the joins easy and proper way.. Read this :http://www.codeproject.com/Articles/33052/Visual-Representation-of-SQL-Joins

Sibeesh Venu · Answer

Hi An inner join of A and B gives the result of A intersect B i.e. the inner part of a venn diagram intersection. An outer join of A and B gives the results of A union B i.e. the outer parts of a Venn diagram union. Read more here : http://stackoverflow.com/questions/38549/difference-between-inner-and-outer-joins You will love reading. Please accept and up vote if it helps you. Kindest Regards Sibeesh Venu http://sibeeshpassion.com/