title: How to get data from two databases in two servers with one SELECT statement?
body: <p>I don't actually want to modify either database, just get the data.</p>
  
  <p>I know how to connect to each database individually, with these connection strings:</p>
  
  <pre><code>Provider=SQLOLEDB.1;Data Source={0};Initial Catalog={1};Integrated Security=SSPI;Persist Security Info=False;
  
  Provider=OraOLEDB.Oracle.1;Data Source={0};User ID={1};Password={2};Persist Security Info=True;
  </code></pre>
  
  <p>But how can I get this overlapping data together? Is that even possible, especially considering that one is <strong>Oracle</strong> and one is <strong>SQL Server</strong>? Or would it be better to do the SELECT statements on each database individually and then match them after?</p>
  
  <hr>
  
  <p>For example, how would I get all students that are 10 years old and like the color blue?
  <img src="https://i.stack.imgur.com/GmizU.png" alt="two tables"></p>
  
  <p>Notice that all items in DatabaseB have an ID that maps to DatabaseA, but not the other way around.</p>