>I'm still wondering though if there was something out there that actually talks about the inner working of a SELECT-SQL statement.

How do you mean? Joe Celko's SQL For Smarties, Second Edition has a lot of inside info. There is a lot in SQL where the compiler makes choices of how to put things together - opening tables "again," making sub-queries, etc.