title: Is possible to join two tables (One Mysql, the other Oracle) from two different servers in PHP?
body: <p>I'll spare the back story, but basically I have two different databases that I retrieve information from. 1 being Oracle (which we've only been given read-only access to) and the other being Mysql (which we have full access to). My problem is there is column in the oracle table that is missing that we would like to pull data from, however that column we need is in the mysql table. Is there a way that I can write a join statement to include this mysql column to the oracle table? I've seen instances online where people have used 'LinkedServers', but I wasn't sure how that worked working in PHP. The DB connections are stored in a php file and the function is called when we want to use that particular database.</p>
  
  <p>tl;dr</p>
  
  <p>Can a user use a join for a mysql and oracle table? if so, how can it be implemented in php when the db info is in a separate php file?</p>
  
  <p>I imagine the sql query would look similar to this:</p>
  
  <pre><code>select
      *
  from
      LocalTable,
      [OtherServerName].[OtherDB].[dbo].[OtherTable]
  </code></pre>
  
  <p>but with some join logic</p>