Coder Perfect

In SQL, what is the difference between a RIGHT & LEFT JOIN and a RIGHT & LEFT OUTER JOIN?


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