Difference between Outer Join and Left Outer Join .

Question

What is difference between Outer Join and Left Outer Join .

Vivek Kumar · Answer

Hi Priyanka, If you just mention JOIN then by default it is an INNER JOIN. An OUTER join has to be LEFT | RIGHT | FULL you can not simply say OUTER JOIN. You can drop OUTER keyword and just say LEFT JOIN or RIGHT JOIN or FULL JOIN Please look into the below link. https://stackoverflow.com/questions/406294/left-join-vs-left-outer-join-in-sql-server

Puneet Kankar · Answer

JOIN TYPES [ { INNER | { { LEFT | RIGHT | FULL } [ OUTER ] } ] ] The keyword OUTER is marked as optional (enclosed in square brackets), and what this means in this case is that whether you specify it or not makes no difference. Note that while the other elements of the join clause is also marked as optional. EXAMPLE FOR JOINS SELECT * FROM A JOIN B ON A.X = B.Y A LEFT JOIN B = A LEFT OUTER JOIN B A RIGHT JOIN B = A RIGHT OUTER JOIN B A FULL JOIN B = A FULL OUTER JOIN B A INNER JOIN B = A JOIN B

Jignesh Kumar · Answer

Hi Priyanka, Please find blogs with clear details for all sql join with resultset for two table. It will clear all concepts of SQL Join https://www.c-sharpcorner.com/UploadFile/63f5c2/joins-in-sql-server/ https://www.c-sharpcorner.com/UploadFile/ff0d0f/joins-in-sql-server/ https://www.c-sharpcorner.com/UploadFile/47fc0a/explain-sql-joins/

Madan Shekar · Answer

Here is the answer: There is absolutely no difference between LEFT JOIN and LEFT OUTER JOIN. The same is true for RIGHT JOIN and RIGHT OUTER JOIN. When you use LEFT JOIN keyword in SQL Server, it means LEFT OUTER JOIN only

Amit Kumar Singh · Answer

Hi Priyanka, Please refer this https://www.dofactory.com/sql/join No such concept of outer join. Thanks, Amit Singh

Rajeev Kumar · Answer

LEFT (OUTER) JOIN : Returns all records from the left table, and the matched records from the right table . RIGHT (OUTER) JOIN : Returns all records from the right table, and the matched records from the left table

Difference between Outer Join and Left Outer Join .

Answers (6)