The ORDER BY expression <expression> includes fields that aren't selected by the query. Only those fields requested in the first query can be included in an ORDER BY expression. (Error 3351)
See Also
In a union query, you have included fields in an ORDER BY expression that are not specified by the query. Only those fields requested in the first query can be included in an ORDER BY expression.