SQL Count Method... Need Help

[AbelaJohnB]

Hello.

I have a table with a field called: ViewTimes


The table has 200+ rows.


I want to count the -total- 'ViewTimes' for -all- 200+ rows.


So, if

ID 1 has 10 views
ID 2 has 2 views
ID 3 has 5 view


It would return: 17



*I remember asking this before... but I can't find my old post *

[DR_LaRRY_PEpPeR]

SELECT SUM(ViewTimes) AS total FROM table

[AbelaJohnB]

oye, thanks Matt!!





*bangs his head against his moniter*