Table join from different servers

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