SQL JOINs? Go read the article from the source ( Visual Representation of SQL Joins) and it’ll make even more sense.

Updates:

• 2020-02-20
  1. LEFT OUTER JOIN is the same as LEFT JOIN (which by extension means that RIGHT OUTER JOIN is the same as RIGHT JOIN)
  2. This link just proved useful: A Visual Explanation of SQL Joins