title: MySql - Inserting multiple rows with a joined subquery?
body: <p>This query will return a list of project IDs that represent forum threads:</p>
  
  <pre><code>SELECT id FROM `proj_objects` WHERE  type='fthread';
  </code></pre>
  
  <p>This query will subscribe a user (whose ID in the users table is '37') to the forum thread with an ID of '122':</p>
  
  <pre><code>INSERT INTO `subscrips` VALUES ( 37, 122 ) ;
  </code></pre>
  
  <p>I'd like to insert multiple rows that will subscribe user 37 to all project objects where type is fthread. Can I do this in a single query?</p>