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

SQL Basics I: Data Queries —covers database terminology and the four basic query types. SQL Basics: SELECT statement options —covers the SELECT statement in detail and explains aggregate ...

The PROC SQL SELECT statement uses a CONNECTION TO component in the FROM clause to retrieve data from the ORACLE table. The Pass-Through query (in italics) is enclosed in parentheses and uses ORACLE ...