Say, I have a table (simple case):
+------+-------+ | id| val| +------+-------+ | 1| 10| | 1| 20| | 2| 5| | 2| 5| | 2| 10| +------+-------+ SELECT id, MUL(val) FROM above_table GROUP BY id; I would get: +----+-----------+ | id| MUL(val)| +----+-----------+ | 1| 200| | 2| 250| +----+-----------+ ****************** I know there is now function MUL(), but is there anything comparable ? Thanx (mysql,query) --------------------------------------------------------------------- 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
