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.

When a PROC SQL query contains subqueries or inline views, the innermost query is evaluated first. In this example, data is retrieved from the SYBASE EMPLOYEES table and returned to the subquery for ...