In this blog post, you’ll learn more about the Sybase Error A CONTAINS query is not allowed on the view or derived table ‘%1’. and the reason for receiving this error
Sybase SQL Error Message
A CONTAINS query is not allowed on the view or derived table ‘%1’.
Reason for this Error
A query expression (a view or a derived table) can only be queried using CONTAINS predicates if it does not use TOP, FIRST, LIMIT, or window aggregates in its nested query blocks. A query expression can only be queried using CONTAINS in the FROM clause if it has one nested query block, and it does not use DISTINCT, GROUP BY, TOP, FIRST, LIMIT, or window aggregates. In addition, the list of columns to search must all come from a single query expression or base table in the FROM clause of each nested query block. If more than one text index is used in the nested query blocks, they must have the same text configuration.
