Subject Re: [ib-support] Cross-db query
Author Svein Erling Tysvaer
Hi Antonio!

>Is Interbase supporting cross-db query?. If not, how I can join two tables
>resides in two different databases?

No, you simply cannot do this. If you need to join them, I guess your best
choice is to import one of the tables into the other database (if you
really need this on a more permanent basis, I guess one-way replication
could be worth looking into). What Interbase do support is transactions
that span several databases, but each query etc. can only be on one
database (exception: the BDE is capable of doing this, but it is a real
performance killer not recommended to try on tables with more than a few
records).

Set