Jonathan Leffler wrote:
>
> FWIW: Informix does not yet allow you to order by a column that is not in
> the select-list. This adheres to the letter of at least one of the old
> SQL standards -- I believe it conforms to entry-level SQL-92, but I'd
> accept a correction that said "No, SQL-89, meaning SQL-86 plus referential
> integrity addendum".
All levels of SQL-92 require that each ORDER BY column be in the select-list.
--
Lee Fesperman, FFE Software, Inc. (http://www.firstsql.com)
===================================================================
* Check out Database Debunkings (http://www.firstsql.com/dbdebunk/)
* "Where Persistent Prevailing Database Fallacies Are Dispelled"
Received on Sat Nov 24 2001 - 01:17:25 CST
