Hi Nick,
Since you talk about external tables, how can I create that kind of tables?. Please, suppose to have two database: "master" and "client", now "master" contains a table "products", "client" contains a table "customers" that have a field "productID" that should point to related product ("product" table to the "master" database). So I ask to everyone, is possible to make in the "client" database an external table that point to "master" "product" table?
thank so much to everyone.
Antonio
ps: I don't need to update that external table, I need to create just a view that join the "customers" table and that "external"

Nick Upson <nick@...> wrote: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



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]