title: insert a value calculated from another table
body: <p>I would like to do a query for inserting a value calculated starting upon another table.
  I don't want to use Temporary tables and I would like to do everything in one singel query.
  It is possible?</p>
  
  <p>I tried this one below but it doesn't work.</p>
  
  <p>Thanks</p>
  
  <p>AFeG</p>
  
  <pre><code>INSERT INTO MyTable( `DATE`, `Name`, `Total` ) 
  VALUES ( 
   '2010/01/01',
   'Thunder',
    SELECT SUM(aValue) FROM AnotherTable
  )
  </code></pre>