we have two databases on two different servers(both Server 2003) - I will call them A server and B server. What we need to do here is joining a table on A server and another table on B together. Using php, we could successfully extract data from the table on A server... but having a trouble with joining this with another table on B server (and vice versa).
The server we will mainly use is A server. Can this joining be done using php functions & queries only? or Is there something we have to do on A server to connect to B server?