I have a table like this name price type A 10 1 B 30 2 A 20 1 B 20 2
would like to distinct based on name and type, do a
sum and get the following result
name price type
A 30 1
B 50 2
How do I do this with one sql query? Thanks.
Claire
_______________________________
Do you Yahoo!?
Express yourself with Y! Messenger! Free. Download now.
http://messenger.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
