Difference between RIGHT & LEFT JOIN vs RIGHT & LEFT OUTER JOIN in SQL
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