A Visual Explanation of SQL Joins.

SELECT * FROM TableA INNER JOIN TableB ON TableA.name = TableB.name

id name id name
-- ---- -- ----
1 Pirate 2 Pirate
3 Ninja 4 Ninja

Many other simple examples:
http://www.codinghorror.com/blog/archives/000976.html