SAND CDBMS SQL Reference Guide
SELECT

 

Previous Topic:
Table Expression Clause
Chapter Index
Next Topic:
Joined Table Clause

 

Remote Table Clause


:: <SELECT statement> ::
The dynamic pass-through query that will be sent to the remote database. If the pass-through query executes successfully, the query results will be returned to the local query in the form of a "virtual" table that can be referenced in other parts of the local query. If the pass-through query fails for any reason, the error message is returned to the local query in place of a set of records.

Note that the full SELECT statement must be contained between double colons ( :: ). A terminating semicolon is not required for the SELECT statement.

connection
This is the name of the connection object used to access the remote database. The connection object must have been defined previously using the CREATE CONNECTION command.