What is the difference in the outcomes of:
Could you perhaps give some instances to illustrate your point?
Asked by User 1034
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%
SQL Join is explained well in this article:
Answered by Mahesh
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
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