I have a database that looks something like this:
[B]Name Week1 Week2 Week3[/B] user1 10 15 7 user2 3 24 2
I need to write an sql select statement that returns 2 columns: the Name column and a Total column which totals that users points for weeks 1 through 3. Is this possible? How can i do it?
Please help! I've been stuck for awhile!