Query from two datasources

Is it even possible to join two tables each from different datasources? From my experience it's not, but I've run into a snag where I need to join the two and I'm hoping I'm very much wrong. And I would hate to run a query and then run a query looping through the results. That is just bad, bad, bad.

Help!

I don't need to run a query for each result. I can set up an array for the second table and match it up. The second table is small.

But I am still curious if it's possible to merge the two tables into one query if each table is from a different datasource.

I think you should be able to run the two queries, and then join them using a Query of Queries.

But from what I've read Query of Queries does not support outer joins. And I need use an outer join.

Am I wrong? Does it allow outer joins?

Not sure, did you check the docs?

Most database also allow you to create proxy or links to other databases. For example, you can set up a link in Oracle and use that like you'd reference another schema. So you might check the database's capabilities. And of course if it is really a requirement that the two DSN's interact with each other, that indicates a design deficiency and it might be time to rethink the database design itself.