I ran into an interesting discussion at work yesterday regarding SQL and how a sane DBMS would handle the following:
SELECT * FROM a
INNER JOIN b
ON a.id = b.game_id
WHERE a.name = ‘wow’
Jeff Atwood has provided a very handy visual guide to how SQL joins work, and I feel I have a good grasp on the basics. [...]