Posted by Plamen Ratchev on 05/04/07 02:27

"Ed Murphy" <emurphy42@socal.rr.com> wrote in message
news:463a637e$0$9929$4c368faf@roadrunner.com...
> Jane T wrote:
>
>
> Basically, the query is processed in this order:
>
> * FROM/JOIN
> * SELECT
> * WHERE
> * GROUP BY
> * HAVING
> * ORDER BY

Ed,

Wouldn't SELECT be much further down in the list, between HAVING and ORDER
BY? Otherwise one might be tempted to write:

SELECT col1 AS mycol
FROM Table
WHERE mycol = 'X';

:)

Plamen Ratchev
http://www.SQLStudio.com

[Back to original message]