SQL Joins - Visualized

Back in 2009, C.L. Moffatt put together this gorgeous cheat-sheet on SQL JOINs

As he put it

I'm a pretty visual person. Things seem to make more sense as a picture. I looked all over the Internet for a good graphical representation of SQL JOINs, but I couldn't find any to my liking. Some had good diagrams but lacked completeness (they didn't have all the possible JOINs), and some were just plain terrible. So, I decided to create my own and write an article about it.

Enjoy...

Hat tip Alex Popescu