Sometimes SQL Anywhere converts a query with the IN operator to one with an ANY operator, and decides whether to convert the
subquery to a join. For example, the following two expressions are equivalent: