title: Combining INSERT SELECT with constants
body: <p>I'm trying to insert records into a table where one of the columns comes from another table. </p>
  
  <p>The other two columns are the same for each record. </p>
  
  <p>All three columns are keys.</p>
  
  <p>I'm trying this embedded INSERT SELECT which I see is not allowed?</p>
  
  <pre><code>INSERT INTO TABLE (COLUMN_A, COLUMN_B, COLUMN_C)
      VALUES (1,(SELECT COLUMN_NAME FROM TABLE) ,2)
  </code></pre>