The syntax for EXISTS conditions is as follows:
EXISTS( subquery )
The EXISTS condition is TRUE if the subquery result contains at least one row, and FALSE if the subquery result does not contain any rows. The EXISTS condition cannot be UNKNOWN.
The EXISTS condition is compatible between Adaptive Server Enterprise and Sybase IQ.
