Table join from different servers

From: JustAQTCub <JustAQTCub_at_comcast.net>
Date: Sat, 24 Feb 2007 20:08:44 -0600
Message-ID: <2t2dnUmpRbQucn3YnZ2dnUVZ_hqdnZ2d_at_comcast.com>

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

Received on Sun Feb 25 2007 - 03:08:44 CET