Problem
What is the difference in the outcomes of:
Could you perhaps give some instances to illustrate your point?
Asked by User 1034
Solution #1
The terms RIGHT JOIN and RIGHT OUTER JOIN are interchangeable. Both are identical. As a result, LEFT JOIN and LEFT OUTER JOIN are interchangeable.
SQL Joins as a Visual Representation
Answered by 18 revs, 6 users 78%
Solution #2
SQL Join is explained well in this article:
Reference: link
Answered by Mahesh
Solution #3
Our very own Jeff Atwood has created a really beautiful Visual Explanation of joins in general. A right outer join and a right join are the same thing, as are a left join and a left outer join.
Answered by Leonard
Solution #4
No difference.
No difference.
Simply put, the OUTER keyword is optional. You can include it or omit it without affecting the resultset.
Answered by onedaywhen
Post is based on https://stackoverflow.com/questions/3183669/difference-between-right-left-join-vs-right-left-outer-join-in-sql