hi,

I would like to join table1 and table2 using a select like this:

SELECT * FROM database1.table1 INNER JOIN database2.table2 ON ...

but database 1 is on a local server and database2 is on a remote server (with different IP address).

Is it possible?

Thanks.

...sorry... I've choosen the wrong forum...

Sybase and MS/SQL can do this but the administration is a bear. I'd guess that Oracle has the ability too but I've never personally set it up.



hi,

I would like to join table1 and table2 using a select like this:

SELECT * FROM database1.table1 INNER JOIN database2.table2 ON ...

but database 1 is on a local server and database2 is on a remote server (with different IP address).

Is it possible?

Thanks.