title: select from one table and insert into another
body: <p>I've got two tables.</p>
  
  <blockquote>
    <p>Table_A (nid, vid, type, title, uid)</p>
    
    <p>Table_B (id, questiontext)</p>
  </blockquote>
  
  <p>I need to insert records from Table_B into Table_A. I tried this:</p>
  
  <pre><code>INSERT INTO Table_A (nid, vid, type, title, uid)
  VALUES ('', '', multichoice', (SELECT questiontext from Table_B), '1')
  </code></pre>
  
  <p>but it's throwing an error.</p>
  
  <p>What should be the correct statement?</p>
  
  <p>UPD: I should add that nid is autoincrement and the value of vid should be same as nid.</p>