All of the databases I've used required the columns in the order by clause also be present in the result set. It may not be universally true though
On 5/26/05, Cronos <[EMAIL PROTECTED]> wrote: > It seems to me that MySQL and PostgreSQL are exhibitting some dubious > guessing behaviour as to which column it refers to, or perhaps they are > making some requirement of the order by to contain a column that is in the > resultset ??? If name were only in test11 then what would MySQL and > PostgreSQL do ? >