|
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
Navigation:
[Reply to this message]
|