The problem comes from the fact that, in an Oracle database ... to the = ANY IN clause compares values returned by the subquery and filters out rows in the outer query; the EXISTS clause compares ...

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 ...