title: Insert multiple rows from select into another table
body: <p>let's say i have `table1(col1,col2,col3), the values to insert on col1 and col3 will be the same, but the values to insert on col2 come from the result of a select query.</p>
  
  <p>How can i write my query so i can do this multiple insert at once ?
  Example of what the query should do : </p>
  
  <pre><code>col1  |  col2   | col3
  
   1        val1     0
   1        val2     0
   1        val3     0
  </code></pre>