Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement. Skip to content ... JOIN, UNION and subqueries.

As a result, you can now create a PROC SQL view, DATA step view, or SAS/ACCESS view with DBMS data. For this example you create a view descriptor, VLIB.ALLEMP, based on SYBASE data. The outer PROC SQL ...