How do nested loop, hash, and merge joins work?

One of the best introductions I've found :-)