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

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