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

For example, the following query subsets PROCLIB.PAYROLL (which is shown in Creating a Table from a Query's Result ) based on the criteria in the subquery. If the value for STAFF.IDNUM is on the same ...