title: If there a way I can inner join a MS Sql table to a MySql Table in one query using MySql?
body: <p>I have 2 servers one servers runs Microsoft SQL Server and the other one is using MySql. </p>
  
  <p>I need to be able to inner join a table from MS SQL name it "A" to a table "B" located on a different server that uses MySql</p>
  
  <p>So I want to be able to do something like this</p>
  
  <p><code>SELECT A.*, B.* FROM A INNER JOIN B ON A.id=B.id LIMIT 100</code></p>
  
  <p>How can I do this? note that both servers are on the same network.  </p>