title: Update multiple columns from subquery
body: <p>This type of thing has been asked a few times before, but is not quite what I am looking for. I need to <code>SET</code> two rows equal to different parts of a subquery.</p>
  
  <p>I am currently using:</p>
  
  <pre><code>UPDATE records
  SET leads=(SELECT COUNT(*) FROM leads_table WHERE leads_table.blah=records.blah),
  earnings=(SELECT SUM(amount) FROM leads_table WHERE leads_table.blah=records.blah)
  </code></pre>
  
  <p>The WHERE statements were obviously simplified...but basically its the same subquery but I don't think I should be running it twice? </p>
  
  <p>I want to do something like...</p>
  
  <pre><code>UPDATE records
  SET (leads,earnings)=(SELECT COUNT(*),SUM(amount) FROM leads_table WHERE leads_table.blah=records.blah)
  </code></pre>