Informix Error -9025
-9025 The column name is not in the current table. Any column used as an
ORDER BY column must be in the current table.The name that is displayed appears after the words ORDER BY, but it is not the name of a column or the display label of an expression that is selected in this statement.