Subject Re: [ib-support] Cross-db query
Author Nick Upson
In article <5.1.0.14.0.20021022122446.02924130@[158.36.132.22]>, Svein Erling
Tysvaer wrote:
> >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

how about if one of the tables is an external table in both tables,
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