Subject Re: [ib-support] Cross-db query
Author Antonio Parrotta
Hi Svein!
concerning the fact of importing the table resides to other db, it's possible without any problems?
thanks
Antonio
Svein Erling Tysvaer <svein.erling.tysvaer@...> wrote: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


Yahoo! Groups SponsorADVERTISEMENT

To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



---------------------------------
MIo Yahoo! : personalizza Yahoo! come piace a te

[Non-text portions of this message have been removed]