[EMAIL PROTECTED] writes:
> Description:
> Hello,
>
>
> When I run the following query:
>
> Select Can as MiCantidad, MiCantidad * 2 from Stocks limit 10
>
> I get the following error:
>
> 'The column 'MiCantidad' in field list is unknown'
>
> So, Can I reference to a column by its alias in a
> select statement?
>
>
> Thanks in advance,
> Rafa
>
> How-To-Repeat:
> Select Can as MiCantidad, MiCantidad * 2 from stocks limit 10
Hi!
This is not a bug.
You can not reference an alias in the select list.
You can do it freely in WHERE, ON , GROUP BY and other clauses.
--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
