I always struggle with queries that are just barely beyond trivial. I tend to forget how relational algebra collides with databases. Here is a really quick visual reminder of how to join shit in SQL.

Graphical Explanation For SQL Joins

Pretty simple huh?

SQL Joins Graphical Explanation

Posted by: fabzter
Last revised: 28 Jul, 2012 04:29 AM History


Your Comments

Used for your gravatar. Not required. Will not be public.
Posting code? Indent it by four spaces to make it look nice. Learn more about Markdown.