In this blog post, you’ll learn more about the Sybase Error Definition for alias ‘%1’ must appear before its first reference and the reason for receiving this error
Sybase SQL Error Message
Definition for alias ‘%1’ must appear before its first reference
Reason for this Error
An expression contains a reference to an alias, but the alias is defined later in the SELECT list. The alias definition must appear before its first reference.