EXISTS

The EXISTS statement determines whether a row exists that satisfies a given condition, as shown in the subquery of the following query:

   SELECT ID, NAME, DEPT
   FROM Q.STAFF CORRVAR
   WHERE EXISTS
     (SELECT * FROM Q.ORG WHERE MANAGER = CORRVAR.ID)

See IN for other methods of conditionally selecting values.