In this article, I’ll discuss some of the more frequently used methods for consolidating data from multiple tables into a single result set: SELECT, JOIN, UNION and subqueries.

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