get grand total

how to get grand total of two years 2001,2002 are fields
this query has error

re: get grand total

Hi.

What error are you getting?

How exactly does your table look like?
(The relevant parts of it, at least.)

re: get grand total

table is like this
schoolid,schoolname,2001(grant),2002(grant)
i want to get total grant of 2001 then i want to get total grant of 2002 then grant total of both totals (tot2001+tot2002)
all three in same row

re: get grand total

How about the error?
What exactly is going wrong with the query?

You should keep in mind tho, that in a query like that, numbers will not be interpreted as column names. If you have column names that are numbers, they must be enclosed in back-ticks (`).

Also, you can not use the aliases for the first two columns to get the sum for the third one. You would have to use the actual column names.