SQL Book Recommendations?

Daniel Myers asks: "I'm designing a MySQL database as a senior project, and I need a decent book on SQL. I've looked at the ORA Msql/MySQL book, but it's not going to be published soon enough for me to use, so does anyone have a decent recommendation? I have some SQL knowledge, but not much (I can write basic SELECT/INSERT/UPDATE statements, but that's about it)."