title: INSERT INTO SELECT with VALUES
body: <p>Is it possible to combine <code>INSERT INTO SELECT</code> with <code>INSERT INTO VALUES</code> ?</p>
  
  <p>say I have :</p>
  
  <pre><code>table1
    Id INT
    value1 INT
    value2 INT
  
  table2
    Id INT
    someothervalue INT
  </code></pre>
  
  <p>Now I want to insert data into table1 :</p>
  
  <ul>
  <li><code>Id</code> will be the Id of table2</li>
  <li><code>value1</code> is a pre-defined value and will always be <code>5</code></li>
  <li><code>value2</code> will be set to <code>someothervalue</code></li>
  </ul>
  
  <p>I can't just use <code>INSERT INTO table1(Id, value1, value2) SELECT Id, someothervalue FROM table2 VALUES(5);</code> So is there a way I can use both <code>VALUES</code> and <code>SELECT</code> to achieve want I want?</p>