Microsoft KB Archive/89932

{|
 * width="100%"|

The information in this article applies to:
 * Microsoft SQL Server version 4.2 for OS/2

BUG# OS/2: 1425 (4.2)

SYMPTOMS
Under certain circumstances, when a SELECT statement with UNION operators has an ORDER BY clause, it gives error 104: &quot;Order By items must appear in the select list if the statement has set operators.&quot;

A SELECT statement with UNION operators can have an ORDER BY clause in it as long as the clause appears once at the end of the last SELECT statement. Furthermore, it is a Transact-SQL extension that the columns appearing in the ORDER BY list need not appear in the select list. But this extension does not hold when the SELECT statement has set operators, such as UNION.

However, if the SELECT statement is of the form

select convert(char, col1) from table1 where UNION select convert(char, col1) from table1 where order by col1 it also gives error 104.

STATUS
Microsoft has confirmed this to be a problem in SQL Server version 4.2 for OS/2. We are researching this problem and will post new information here as it becomes available.
 * }

-

Last reviewed: April 28, 1997

© 1998 Microsoft Corporation. All rights reserved. Terms of Use.