[thelist] Silly SQL

[Ken Kogler]

Greetings, all. I've got a query that looks like this:

  select vUserVotedFor as user,
         sum(vCitizenship) as ciTotal,
         sum(vLeadership) as leTotal,
         sum(vAcademics) as acTotal,
         sum(vCharacter) as chTotal
  from tblVotes 
  group by vUserVotedFor

And that returns this:

  User        ciTotal leTotal acTotal chTotal
  ----------- ------- ------- ------- -------
  Ablood        55      55      40      50
  Bruckman      63      65      59      62
  Tkrimminger   59      65      55      59
  Jhines        66      66      68      68
  Jmward        61      65      66      63
  Ccrouch       60      63      65      63

What I'm looking for is a way to also return the total of all four
numeric columns added together (ciTotal + leTotal + acTotal + chTotal =
???). I want to return the total score for each user. I tried nesting
another query in there, but I can't quite get my brain around how this
is supposed to work. 

I know I can just work with the recordset through ASP/PHP/whatever, but
I won't learn anything that way. I want to see if I can get it to work
through SQL. This is SQL Server 2000 running on Win2k if that helps.

Any thoughts?

--ken