Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » SQL Anywhere Server - SQL Usage » Remote data and bulk operations » Remote data access


Joins between remote tables

The following figure illustrates proxy tables on a local database server that are mapped to the remote tables Employees and Departments of the SQL Anywhere sample database on the remote server RemoteSA.

The remote tables and proxy tables are mapped.

You can use joins between tables on different SQL Anywhere databases. The following example is a simple case using just one database to illustrate the principles.