You might want to pick up a copy of Itzik Ben-Gan's Inside SQL Server TSQL Querying. You're missing out on some core logical constructs as to how TSQL works and how SQL Server works with it. Read through the first two chapters on query processining. They lay out the methods used by the optimizer and query engine such that you'll see better how to deal with this construction issue that you're hitting.