Introduction

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.