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.