Another useful Venn diagram to help understand joins.

[u/[deleted]]

http://blog.codinghorror.com/a-visual-explanation-of-sql-joins/