In this blog post, you’ll learn more about the Sybase Error Function or column reference to ‘%1’ in the ORDER BY clause is invalid and the reason for receiving this error
Sybase SQL Error Message
Function or column reference to ‘%1’ in the ORDER BY clause is invalid
Reason for this Error
You specified a function or column reference in the ORDER BY clause that is semantically invalid. For example, for DISTINCT queries the ORDER BY clause may only refer to items in the query’s SELECT list.