title: How can I SQL insert a record for every id in another table?
body: <p>I've seen the insert select but I only want to get one value from the second table.  Here's what I'm thinking:</p>
  
  <pre><code>insert into table1
  Values((select distinct id from table2),
  "blah", "blah", "blah")
  </code></pre>
  
  <p>So after the Id, the rest of the values will be hard coded to whatever I want.  Is this possible?</p>