in reply to SQL Database Help!!
select field1, sum(field2), sum(field3), sum(field4) from table group by field1 order by field1 [download]