EXISTS (SQL Server Compact)
Specifies a subquery to test for the existence of rows.
The following example finds all orders in the Orders table, with "Washington" as the Shipping Region, for each employee listed in the Employees table.
SELECT * FROM Orders WHERE [Ship Region] = 'WA' AND EXISTS (SELECT [Employee ID] FROM Employees AS Emp WHERE Emp.[Employee ID] = Orders.[Employee ID])