Re: problem with column alias

#1 July 27th, 2008, 10:15 PM

You cannot use a column alias in the definition of another column. The
solution is as you found to repeat the expression. Alternative solution is
to define the first column in one CTE (or derived table) and then use the
column in a second CTE.

Also, it is good to define a valid column name (not a revered keyword) and
then change it to whatever you want in the final SELECT (or client
application).

Plamen Ratchev
http://www.SQLStudio.com

#2 July 27th, 2008, 10:15 PM

On 27 Èec, 23:06, "Plamen Ratchev" <Pla...@SQLStudio.comwrote:

Quote:

You cannot use a column alias in the definition of another column. The
solution is as you found to repeat the expression. Alternative solution is
to define the first column in one CTE (or derived table) and then use the
column in a second CTE.
>
Also, it is good to define a valid column name (not a revered keyword) and
then change it to whatever you want in the final SELECT (or client
application).
>
Plamen Ratchev

Thank you, you're probably right about that keyword..
Jan

Re: problem with column alias

re: Re: problem with column alias

/bytes/development

/bytes/it

/bytes/about