Outer Join in SQL Server

Question

Hi friends I want to know what is outer join in SQL Server. Thank you.

Kunal Vaishya · Answer

Dear Please Refer this link http://msdn.microsoft.com/en-us/library/ms187518.aspx

Satyapriya Nayak · Answer

Hi Vipender Please refer the below links http://www.1keydata.com/sql/sqlouterjoin.html http://www.w3schools.com/sql/sql_join_left.asp http://www.w3schools.com/sql/sql_join_right.asp http://www.w3schools.com/sql/sql_join_full.asp Thanks

MuthuMari M · Answer

Hi OUTER JOIN is used to join two tables even if there is not a match. An OUTER JOIN can be used to return a list of all the customers and the orders even if no orders have been placed for some of the customers. A keyword RIGHT or LEFT is used to specify which side of the join returns all possible rows. I like using LEFT because it makes sense to me to list the most important table first. Except for one example demonstrating RIGHT OUTER JOIN this article will use left joins. Just a note: the keywords INNER and OUTER are optional. LEFT OUTER JOIN - Based on the two tables specified in the join clause all data is returned from the left table. On the right table the matching data is returned in addition to NULL values where a record exists in the left table but not in the right table. Another item to keep in mind is that the LEFT and RIGHT OUTER JOIN logic is opposite of one another. So you can change either the order of the tables in the specific join statement or change the JOIN from left to right or vice versa and get the same results. RIGHT OUTER JOIN - Based on the two tables specified in the join clause all data is returned from the right table. On the left table the matching data is returned in addition to NULL values where a record exists in the right table but not in the left table. FULL JOIN - Based on the two tables specified in the join clause all data is returned from both tables regardless of matching data. pls refer this url http://www.sqlteam.com/article/writing-outer-joins-in-t-sql http://www.mssqltips.com/sqlservertip/1667/sql-server-join-example/ thanks. If this post is useful then mark it as  Accepted Answer