Subject | Re: [ib-support] Cross-db query |
---|---|
Author | Nick Upson |
Post date | 2002-10-26T18:51:31Z |
In article <5.1.0.14.0.20021022122446.02924130@[158.36.132.22]>, Svein Erling
Tysvaer wrote:
that way the data would be visible to both databases.
Nick
-----We Solve your Computer Problems---
Founder & Listowner of the Prolifics User Group
Panther, Ingres, UNIX, Interbase - Available Shortly
Tysvaer wrote:
> >Is Interbase supporting cross-db query?. If not, how I can join two tableshow about if one of the tables is an external table in both 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
that way the data would be visible to both databases.
Nick
-----We Solve your Computer Problems---
Founder & Listowner of the Prolifics User Group
Panther, Ingres, UNIX, Interbase - Available Shortly