This list of solutions to common SQL query problems is insane. It's incredibly useful and deep. http://www.artfulsoftware.com/infotree/queries.php?&bw=1280