SQL Concept

SQL Joins

Table Join

SQL Equivalent Syntax

Inner , Outer , Cross

Outer Join , Left Outer , Right Outer

 Left Join and Left Outer Join Tip !!!

Right Join and Right Outer Join Tip !!!

References : 

1.difference between inner and outer joins

http://stackoverflow.com/questions/38549/difference-between-inner-and-outer-joins

2.sql join and different types of joins

http://stackoverflow.com/questions/17946221/sql-join-and-different-types-of-joins

3.left join and left outer join in sql server

http://stackoverflow.com/questions/406294/left-join-and-left-outer-join-in-sql-server