Comment by deanfranks

"SQL for Smarties", Joe Celko -- an excellent resource