Difference between RIGHT & LEFT JOIN vs RIGHT & LEFT OUTER JOIN in SQL [duplicate]

This question already has answers here: 开发者_如何学JAVA LEFT JOIN vs. LEFT OUTER JOIN in SQL Server (12 answers) Closed 3 years ago.

What is the difference in results between:

1. RIGHT JOIN and RIGHT OUTER JOIN
2. LEFT JOIN and LEFT OUTER JOIN ?

Can you please explain it through some examples?

---

There is no difference between RIGHT JOIN and RIGHT OUTER JOIN. Both are the same. That means that LEFT JOIN and LEFT OUTER JOIN are the same.

Visual Representation of SQL Joins

---

Nice explanation of SQL Join:

Reference: link

---

Here's a very nice Visual Explanation of joins generally by our very own Jeff Atwood. A right outer join is the same as a right join, and left join and left outer join are also the same.

---

What is result difference between:

RIGHT JOIN and RIGHT OUTER JOIN

No difference.

LEFT JOIN and LEFT OUTER JOIN ?

No difference.

Simply put, the OUTER keyword is optional. You can include it or omit it without affecting the resultset.