MrBillybob Posted September 14, 2007 Share Posted September 14, 2007 is it possible to do a join from two different servers? If so how? Quote Link to comment Share on other sites More sharing options...
gerkintrigg Posted September 14, 2007 Share Posted September 14, 2007 not that I know of. Excellent question. What you'll probably need to do is get one set of data from one server, then change the MySQL connect script and use the data you got from the first server in the conditions for the second SQL query. It's not a good idea to use more than one server for only one script execution, but if you need to do it... that's probably the only way you can. Quote Link to comment Share on other sites More sharing options...
fenway Posted September 15, 2007 Share Posted September 15, 2007 You can try and use FEDERATED tables. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.