The EXISTS condition is an operator whose right operand is a subquery ... Thus, the query returns all the employees from PROCLIB.PAYROLL who live in CT. proc sql; select * from proclib.payroll p where ...

In another thread someone suggested I use MINUS, but I was under the impression that only Oracle had the MINUS function, does SQL Server 2005 also have this option?<BR><BR>(I know I can use NOT ...