title: Adding MySQL alias fields together
body: <p>Consider a query similar to:</p>
  
  <pre><code> SELECT sum(EXPR) as total,
          sum(EXPR) as total2, 
          sum(total+total2) as grandtotal 
   FROM tablename
  </code></pre>
  
  <p>This comes up and says unknown column total in field list.</p>
  
  <p>Is there anyway to reference the alias fields in a calculation without retyping the sum expression because <code>sum(EXPR)</code> on each side is very long.</p>