Where SubQuery

In and NotIn are two of the most common operators used in a Where SubQuery. The following produces a result set containing Territories that an Employee is not associated with.

C#

VB

Produces the following SQL

Exists evaluates to true, if the SubQuery returns a result set.

C#

VB

Produces the following SQL