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

In most implementations of SQL, you pull information from two tables by using a SELECT command in this form: SELECT table1.column1, table1.column2, table2.column1, table2.column2 ...