Inner Join Vs Outer Join vs Cross Join
Difference between Inner Join,Outer Join and Cross Join in Sql ???
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Pranay RanaPosted Feb 5, 2015, 4:18 AM
Read this :http://www.codeproject.com/Articles/33052/Visual-Representation-of-SQL-Joins
Sibeesh VenuPosted Feb 5, 2015, 1:00 AM
Read more here :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.
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/