Re: Select a column that is not in the order-clause ?
On 4 May 98 16:05:20 GMT, derix@forwiss.uni-passau.de (Bernhard Derix)
wrote:
>
>
>Is this possible ?
>I'd like to sth. like this:
>
>select columnY
>from (select *
> from tableXY
> order by columnX);>
>But this syntax isn't possible.
Though this is part of the ANSI SQL 92 standard, for some reason
Informix doesn't support it. Try their support line, and suggest it
as an enhancement.
Ciao
Fuzzy
:-)