Re: cross database joins
From: Chris Kimpton <psx-info_at_quarks.idiscover.co.uk>
Date: 1996/07/12
Message-ID: <31E730CA.782E_at_quarks.idiscover.co.uk>#1/1
Date: 1996/07/12
Message-ID: <31E730CA.782E_at_quarks.idiscover.co.uk>#1/1
vance wrote:
>
> Is it possible to have a join drawing from tables that are in two different
> database on different machines in a TCP/IP network?
Assuming that on either machine (or a third) you can create a database link to the other - then yes.
...but be careful - I did something similar in Access to Oracle, mixing local and remote tables - the query ran like a dog.
Its probably worth using cursors so you control what is accessed when.
Regards,
Chris
Received on Fri Jul 12 1996 - 00:00:00 CEST