Re: Select Sum(~~~), Sum(~~~) Error. :(

[Jörg Z]

I'm not sure if my answer is helpful. But your question seems to be a bit similiar to my problem: How can I collect results to be shown in one row. My solution (without sum but with the max() function) is documented here:
[link]http://forums.mysql.com/read.php?10,648188,648414#msg-648414[/link].
The general way ist to define a main query which gives the structure (the output to be seen) and subqueries. The subqueries bring out the results and the main query gives the layout of the result. Hope that this hint is helpfull for you.