Nick,
I know that this way can lower the prformance, but take in mind that at this moment I'm using an Access database, so the losing of performance depends of the point of view :-).
Concerning the external table, can you give me a simple example writing a query that join two table resides in two different db?
I will appreciate so much
Thanks
Antonio
Nick Upson <nick@...> wrote:In article <20021028094338.87249.qmail@...>, Antonio Parrotta wrote:

> Hi Nick,
> Since you talk about external tables, how can I create that kind of tables?.

Create table tablename external "c:\tmp\mytmpdb.gdb"
<col def> etc

> 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.

Yes, just make sure you use the same definition in both databases.

> 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"

it should work, but performance will be lousy. Set it up so that the
smallest table (of products & customers) is the external one.






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]