This chapter shows you
how to perform the following tasks:
-
select data from more than one
table by joining the tables together
-
use subqueries to select data from
one table based on data values from another table
-
combine the results of more than
one query by using set operators
Note: Unless otherwise noted, the
PROC SQL operations that are shown in this chapter apply to views
as well as tables. For more information about views, see
Creating and Updating Tables and Views.