--
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 17, 2004 2:54 PM
Subject: Query to another server
Is it possible to query one server from another even if those servers are
in diferent machines at diferent locations?
for example:
selec
<[EMAIL PROTECTED]>
17/02/2004 12:52 a.m.
To
Terence <[EMAIL PROTECTED]>
cc
[EMAIL PROTECTED]
Subject
Re: Query to another server
You might be able to cheat and replicate the required database to the
local machine.
Regards,
Chris
Terence wrote:
>you'll need to create tem
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 17, 2004 2:54 PM
Subject: Query to another server
Is it possible to query one server from another even if those servers are
in diferent machines at diferent locations?
for example:
select * from localtable left join remoteserver.remotedat
you'll need to create temporary tables in one of the servers based on the
results of the other and then join.
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 17, 2004 2:54 PM
Subject: Query to another server
Is it poss
I dont think so :(
Karam
--- [EMAIL PROTECTED] wrote:
> Is it possible to query one server from another even
> if those servers are
> in diferent machines at diferent locations?
>
> for example:
>
> select * from localtable left join
> remoteserver.remotedatabase.remotetable
>
> where localta
On Mon, Feb 16, 2004 at 11:54:43PM -0700, [EMAIL PROTECTED] wrote:
> Is it possible to query one server from another even if those servers are
> in diferent machines at diferent locations?
>
> for example:
>
> select * from localtable left join remoteserver.remotedatabase.remotetable
>
> where
Is it possible to query one server from another even if those servers are
in diferent machines at diferent locations?
for example:
select * from localtable left join remoteserver.remotedatabase.remotetable
where localtable.key = remoteserver.remotedatabase.remotetable.key
FBR
