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

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