Re: Popular affiliates query problem

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"