-197 A QUALIFIED COLUMN NAME IS NOT ALLOWED IN THE ORDER BY CLAUSE WHEN A SET OPERATOR IS ALSO SPECIFIED
Explanation
The ORDER BY clause of a fullselect that includes a set operator, such as UNION, EXCEPT, or INTERSECT, cannot have qualified column names.
System action
The statement cannot be processed.
Programmer response
Change the statement to ensure that all column names in the ORDER BY clause are unqualified.
SQLSTATE
42877