title: Oracle: INSERT on condition from other table
body: <p>I am trying to create a SQL query where I need to insert a new sets of records based but 1 column is needed from required table.</p>
  
  <p>E.g.,</p>
  
  <pre><code>TABLE_1
  =======
  ID,
  A,
  B
  
  TABLE2
  ======
  ID, 
  C, 
  D
  </code></pre>
  
  <p>Each <code>ID</code> are identical ID column.</p>
  
  <p>I have a query of this format:</p>
  
  <pre><code>INSERT INTO TABLE_1 (ID, A, B) VALUES (???, "Yes", "What")
  WHERE ID IN (SELECT ID FROM TABLE_2 WHERE ID &gt; 10)
  </code></pre>
  
  <p>This, clearly doesn't work.</p>
  
  <p>My question: how do I add the <code>ID</code> value from Table 2 into Table 1 and make it runnable? This is a query that must run on Oracle 11g.</p>