Here's my sql statement so far
SELECT DISTINCT email, fromemail, viewnum from TABLE
I want an SQL statement that will add the numbers in the field viewnum.
Here's a sample output
email fromemail viewnum
email@example.com firstname.lastname@example.org 34
email@example.com firstname.lastname@example.org 4
so basically i want the statement to give me 38.
Thanks, hope this was clear.