title: C# - Join tables from two different databases using different ODBC drivers
body: <p>I have a C# application which needs to pull data from two different databases:
  Database 1 is a MYOB database (which uses ODBC to connect using MYOB's driver)
  Database 2 is an Access database, again I'm using ODBC to connect to it.</p>
  
  <p>Eg. this is the query I would like to run:</p>
  
  <pre><code>$query = "SELECT * FROM [" + myobConnectString + "].Accounts, ["+accessConnectString+"].tblTest WHERE tblTest.ID = Accounts.AccountID";
  </code></pre>
  
  <p>My question is how can I run this (or if it's even possible)?</p>
  
  <p>Thanks!</p>