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.