Introduction

This chapter shows you how to

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

Copyright © 2008 by SAS Institute Inc., Cary, NC, USA. All rights reserved.