Coding Horror offers a primer on SQL JOINs using set theory’s Venn diagrams.

Venn diagrams are a very convenient mechanism for visualizing the union and intersection of two sets. Think of each table in a database a set. This primer illustrates how various SQL JOINs between tables can be visualized as unions and intersections.

(more…)