The SQL Procedure

CONNECTION TO

Retrieves and uses DBMS data in a PROC SQL query or view.

Tip: You can use CONNECTION TO in the SELECT statement's FROM clause as part of the from-list.

See also: Connecting to a DBMS Using the SQL Procedure Pass-Through Facility and your SAS/ACCESS documentation.

CONNECTION TO dbms-name (dbms-query)

CONNECTION TO alias (dbms-query)

alias specifies an alias, if one was defined in the CONNECT statement.
dbms-name identifies the DBMS you are using.
dbms-query specifies the query to send to a DBMS. The query uses the DBMS's dynamic SQL. You can use any SQL syntax that the DBMS understands, even if that is not valid for PROC SQL. However, your DBMS query cannot contain a semicolon because that represents the end of a statement to the SAS System.
The number of tables that you can join with dbms-query is determined by the DBMS. Each CONNECTION TO component counts as one table toward the 32-table PROC SQL limit for joins.

Tip:	You can use CONNECTION TO in the SELECT statement's FROM clause as part of the from-list.
See also:	Connecting to a DBMS Using the SQL Procedure Pass-Through Facility and your SAS/ACCESS documentation.