title: Can I join between two MySQL tables stores on separate machines?
body: <p>I have a relatively light query that needs information from a local MySQL table along with another MySQL table which is stored on a physically separate machine (on the same network).  I'm keen to avoid setting up replication just to facilitate this light query that only needs executed once a day.</p>
  
  <p>Is there any way that I can join with a table on a remote machine using one query?  Or run a SELECT INTO into a local table.</p>
  
  <hr>
  
  <p><strong>Notes</strong></p>
  
  <ul>
  <li>I'm using C# &amp; .NET 4.</li>
  </ul>