SELECT binding order
From http://msdn.microsoft.com/en-GB/library/ms189499.aspx.
SELECT statement clauses are bound in this order:
- FROM
- ON
- JOIN
- WHERE
- GROUP BY
- WITH CUBE/WITH ROLLUP
- HAVING
- SELECT
- DISTINCT
- ORDER BY
- TOP
From http://msdn.microsoft.com/en-GB/library/ms189499.aspx.
SELECT statement clauses are bound in this order: