If you are using ODBC, create an ODBC data source name for each database you will be accessing.

Connect to the database from which you will be performing the join. For example, connect to db1.

Perform a CREATE SERVER statement for each other local database you will be accessing. This sets up a loopback connection to your SQL Anywhere server.

CREATE SERVER remote_db2
CLASS 'saodbc'
USING 'RemoteSA_db2';
CREATE SERVER remote_db3
CLASS 'saodbc'
USING 'RemoteSA_db3';

Create proxy table definitions by executing CREATE EXISTING TABLE statements for the tables in the other databases you want to access.

CREATE EXISTING TABLE Employees
AT 'remote_db2...Employees';