how to sum a field if others are the same

[christheprogrammer]

Ok I feel like an idiot. How do you do this simple thing -
Here is an example of the fields:

Field1 Field2 Field3 Weight
apple sweet red 2
apple sweet red 3
orange sour orange 1
orange sour orange 3
orange sweet orange 6

And I want this:

apple sweet red 5
orange sour orange 4
orange sweet orange 6

The last field is just a sum of the others with the same field values...
I used to write complex SQL statements but I can't even do this now - definately not like riding a bike.. frustrating as hell
Cheers

Later

 

[christheprogrammer]

sorry i erred -
the input should be:

apple sweet red 1
apple sweet green 2
etc

and the query should total the "sweet apples"..
and give:

apple sweet 3

Later

 

[mpastore]

select field1,field2,count(*) from mytable group by field1,field2

Mike Pastore

Hats off to (Roy) Harper