title: Querying a database and insert resulting into a table in a seperate database in Oracle SQL Developer
body: <p>Hi I have two database connections in Oracle SQL developer. I am trying to query results out of one database and insert them into another. If one database is named Issue and the other one named Hub. The table I want the results to go in is in the DB Hub. So in a worksheet in the hub database would I do something like this?</p>
  
  <pre><code>INSERT INTO RESULTS
  SELECT ...
  FROM ISSUE.TABLE1 ISSUE1,
  ISSUE.TABLE2 ISSUE2,
  WHERE ...
  </code></pre>
  
  <p>However when I do this I get this error:</p>
  
  <pre><code> SQL Error: ORA-00942: table or view does not exist
   00942. 00000 -  "table or view does not exist"
  </code></pre>
  
  <p>I am connecting to the database Issue incorrectly? </p>
  
  <p>Thanks,</p>