Re: Order By non Select column?

On Mon, 28 Feb 2000 19:07:32 +1100, David Pattinson <dpattinson@enternet.com.au> wrote: >Is it possible to order by a column which is not in the select clause of >an SQL statement in Informix? (Unfortunately I don't have a copy of >Informix available to test on). > >Regards, David. No, it is error: "309: ORDER BY column (column_name) must be in SELECT list." -- Jiří Lisický ČD DATIS Olomouc e-mail: lisicky@datis.cdrail.cz Nerudova 1 phone: +420-068-472-5496 Olomouc, Czech Republic >>> čeština ISO-8859-2 Compatible <<<