According to Ben-Gan’s “Inside Microsoft SQL Server 2008_ T-SQL Querying”, -ORDER BY- takes the output of SELECT (so called VT5) as input to sort the rows. Based on my understanding of the concept of ‘logical processing order’, the VT5 is all that the ORDER BY can work with, so how can ORDER BY order by columns that are not in VT5?