I ave two tables.
Table B from database A
table B from database B
Both databases are on the same SQL server.
I need to join these two tables.
I can use focus code and do the join.
But, I am trying to avoid focus code and use sql passthru.
Is there a way to connect to two databases via SQL passthru?
something like
ENGINE SQLMSS SET DEFAULT_CONNECTION database connection A, database connection B.
Is there a way to do this?
Thank you.

This message has been edited. Last edited by: ReddyP,

The adapters connect to SQL Server instances with potentially a default database. You have access to all the databases under the same instance. Prefix the table names with the database and user space name (or whatever the **** they are called).

Yes, it worked. Thank you.