Differences and visual representation of SOL joins:

Original article: Visual Representation of SQL Joins

Also check this post: SQL SERVER – Join Better Performance – LEFT JOIN or NOT IN?