You would be correct Claudio. MySQL doesn't allow that statement. I just
tried it. This did work though. I am running the lastest version of stable
release of MySQL.

select col1*10 as a, col2+5 as b, (col1*10)+(col2+5) as c from testtable
order by c ,b,a

----- Original Message -----
From: "Claudio Valderrama C." <cvalde@...>
To: <IB-Architect@yahoogroups.com>
Sent: Thursday, March 01, 2001 10:43 PM
Subject: RE: [IB-Architect] SQL Expressions


> > -----Original Message-----
> > From: Ian A. Newby [mailto:ian@...]
> > Sent: Jueves 1 de Marzo de 2001 7:18
> >
> > Hi All,
> > In other SQL databases, the expression
> >
> > select col1 * 10 as a, col2 + 5 as b, a + b as c from mytable order
> > by c, b, a
> >
> > is allowed.
>
> Ian, what other engines? Last time I tried in MsSql, it refused the
> statement. Haven't tried with v2000, though.
>
> C.
>
>
> To unsubscribe from this group, send an email to:
> IB-Architect-unsubscribe@onelist.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>