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

Comments

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.

Preview