Support Request System
View Patch #60.101.080
Can't open a spare turnaround. Get SQL error about ORDER by clause
When running under SQL 2000, attempting to open any turnaround to idenify spares results in "ORDER BY items must appear in the select list if the statement contains a UNION operator"
This is actually a result of a bug in SQL 2000 where the parser gets confused between an ORDER BY in a sub-SELECT and an UNION between main SELECTs. The SQL statement has been changed to work around the problem with SQL 2000. Note that SQL 2005 and 2008 were unaffected.
Find a Patch
Return to Request System Menu