Possible Duplicate: Why is the SELECT clause listed first? While trying to write a query, I found out (the hard way) that SQL Server reads WHEREs in a query long before reading the SELECTs when executing a query. As a programmer (not a DBA), I found this somewhat confusing, since it s...