[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
[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