sum the values in a group by statement....

Hi,

Can someone give me the mysql syntax or a reference link where I can learn how
to group the values in a select statement and also ADD the values of
some of the columns. 

For example:

select column1, column2, column3 from table1 group by 1 asc,2 desc;

I want the values presented in the column3 to be the sum of all the rows
that matched the group condition. 

Am I clear enough?


Thank you.
Ciprian


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <mysql-thread113336@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail 
<mysql-unsubscribe-gcdmg-mysql=m.gmane.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php