Expression subqueries are included in a query’s select list or that are introduced by >, >=, <, <=, =, or !=. Adaptive Server converts, or flattens, expression subqueries to equijoins if:
The subquery joins on unique columns or returns unique columns, and
There is a unique index on the columns.
