In this blog post, you’ll learn more about the Sybase Error Correlation name ‘%1’ is not valid for use with the ROWID function and the reason for receiving this error
Sybase SQL Error Message
Correlation name ‘%1’ is not valid for use with the ROWID function
Reason for this Error
The correlation name used was not valid for the ROWID function. Only the correlation names of base tables, temporary tables, global temporary tables or proxy tables may be used with the ROWID function. The argument of a ROWID function should not refer to a view, derived table, common table expression, or a procedure.