Difference between Outer Join and Left Outer Join .

Priyanka Singh

7y1.2k

What is difference between Outer Join and Left Outer Join .

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vivek Kumar7y ago
Accepted 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
Rajeev Kumar3y ago
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
Puneet Kankar7y ago
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 Kumar7y ago
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 Shekar7y ago
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 Singh7y ago
Hi Priyanka,
Please refer this
https://www.dofactory.com/sql/join

No such concept of outer join.

Thanks,
Amit Singh