On Thu, 21 Oct 1999, Zeugswetter Andreas IZ5 wrote:
> > select distinct f1 from t1 order by f2;
> >
> > Returned the following message under Oracle8 on NT:
> > ORA-01791: not a SELECTed expression
>
> Informix: 309: ORDER BY column (f2) must be in SELECT list.
The version of sybase I tried earlier was 4.9.2. I just tried it
again on 11.5 -- same thing.
Vince.
--
==========================================================================
Vince Vielhaber -- KA8CSH email: vev@michvhf.com flame-mail: /dev/null # include <std/disclaimers.h> Have you
seenhttp://www.pop4.net? Online Campground Directory http://www.camping-usa.com Online Giftshop
Superstore http://www.cloudninegifts.com
==========================================================================