EXISTS
Purpose
This tests whether the specified subquery contains result rows.
Syntax