Learn what the EXISTS operator is, why it is useful, and how to use it in SQL queries to check for data in a subquery. Also, learn how to use the NOT EXISTS operator.

For this example you create a view descriptor, VLIB.ALLEMP, based on SYBASE data. The outer PROC SQL query retrieves data from the view descriptor; the subquery uses a Pass-Through query to retrieve ...