Re: Table join from different servers

From: snlrice <snlrice_at_charter.net>
Date: Sun, 20 May 2007 19:06:58 -0500
Message-ID: <so54i.54$gN1.31_at_newsfe12.lga>


JustAQTCub wrote:
> Is it possible to obtain data from two different databased, each being on a
> different server. How would the query be written?
>
> example:
>
> TABLE1 on SERVER1 db1name/db1pass_at_instance1
> TABLE2 on SERVER2 db2name/db2pass_at_instance2
>
> TABLE1
> --------------------
> column_a1
> column_b1
> column_c1
>
> TABLE2
> ---------------------
> column_a2
> column_b2
> column_c2
>
>
> TABLE JOIN:
> column_a1 column_a2 column_b2 column_c1
> ----------- ------------ ------------ -------------
> apple fruit red tree
> orange fruit orange tree
> grape fruit purple vine
> pumpkin vegetable orange vine
>
>

why not establish a database link then just refernce the othertable_at_your link? Received on Mon May 21 2007 - 02:06:58 CEST

Original text of this message