Mysql or standard sql advanced manual

Hello,
I'd like to know from the experts on the group some good mysql or
standard sql manuals (printed or online, and also some good sites)
primarly for the query construction with complex joins and also for
optimization and other arguments.
Thank you in advance.
Asteddy