Alias Error in a select statement

2003-03-26 Thread rafarife
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?

Re: Alias Error in a select statement

2003-03-26 Thread Sinisa Milivojevic
[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

Re: Alias Error in a select statement

2003-03-26 Thread Paul DuBois
[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