How nested loop, hash, and merge joins work.