Fast an Easy SQL question!!

[Al Neri]

I have a table as such:

UID...AccountID.....Instance.....Value
1.........1.....................1............100
2.........2.....................1............200
3.........2.....................2............200
4.........3.....................1............300
5.........4.....................1............400
6.........4.....................2............500
7.........4.....................3............600
8.........5.....................1............400


How can I have it add up all the instances for a single account and give me the totals, ie output


acct........total value
..1..........100
..2..........400
..3..........300
..4..........1500
..5..........400


Thanks!

 

[VenomXTF]

Something along these lines.

SELECT AccountID, SUM(Value) As Total FROM Accounts GROUP BY AccountID