 |
|
| Retrieving Data from Multiple Tables |
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. ![[cautionend]](../../../../common/61991/HTML/default/images/cautend.gif)
|
|
Copyright © 2008 by SAS Institute Inc., Cary, NC, USA. All rights reserved.