Adding MySQL alias fields together

Question

Consider a query similar to:

 SELECT sum(EXPR) as total,
        sum(EXPR) as total2, 
        sum(total+total2) as grandtotal 
 FROM tablename

This comes up and says unknown column total in field list.

Is there anyway to reference the alias fields in a calculation without retyping the sum expression because sum(EXPR) on each side is very long.

Answer 1

SELECT total, total2, total + total2 as grandtotal from (
 SELECT sum(EXPR) as total, 
        sum(EXPR) as total2,  
 FROM tablename 
) x

Answer 2

SELECT
WITH Sums AS
(
 SELECT sum(EXPR) as total, 
        sum(EXPR) as total2
 FROM tablename 
)
SELECT SUM(sums);

for you tsql fans...

Answer 3

You could use variables:

http://dev.mysql.com/doc/refman/5.0/en/user-variables.html

Answer 4

SELECT @total1 := sum(EXPR), 
       @total2 := sum(EXPR),  
       @total1 + @total2 as grandtotal  
FROM tablename