GetDatasetByQuery over multiple database connections?

[pbakker]

Can this be done? Since you have to specify the database connection against which to run the query, it looks to me like it's not possible right now, or am I wrong?

I know that in Oracle, you can run a query on one DB, but in the SQL statement specify tables from other DB's ( select * from table1, table2@database2 where......) Is this possible?

Paul

[Jan Blok]

if your targeted db knows about the other db instance yes