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 Sun May 20 2007 - 19:06:58 CDT
