EXISTS

The EXISTS statement determines whether a row exists that satisfies a given condition.

This is 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)