title: Inner join query from SQL Server and Oracle with Python
body: <p>Let's say I have a query like such:</p>
  
  <pre><code>SELECT Oracle.Column1, SqlServer.Column1
  FROM SqlServer
  INNER JOIN Oracle
  on SqlServer.ID = Oracle.ID
  </code></pre>
  
  <p>I have established cursor connections in python to their respective databases using Cx_Oracle and pyodbc. Individual queries work great. Subqueries I can do. But this query with an inner join that requires both a connection to Oracle AND SQL Server I'm lost. How do I break this up or approach this programmatically? </p>
  
  <p>My current version involves creating temp tables but that only works in SQL Server, not Oracle! The goal would be to use cursors to connect to their respective servers(can currently accomplish) but then what?</p>