The ORDER BY expression <expression> includes fields that are not selected by the query. Only those fields requested in the first query can be included in an ORDER BY expression. (Error 3351)

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.



Community Additions

Show:
© 2014 Microsoft