well the result is correct. the sum of first is 1 for the first record. the sum of first AND second would be 3.
select first, second, sum(first + second) from example; is that what you want? Rgds Terence ----- Original Message ----- From: "Kevin" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, October 10, 2002 10:36 AM Subject: Help with Sum(), newbie OK. Maybe I'm expecting too much of myself, but I can't figure out what I am doing wrong here: mysql> select * from example; +-------+--------+ | first | second | +-------+--------+ | 1 | 2 | | 2 | 3 | +-------+--------+ 2 rows in set (0.00 sec) mysql> select first, second, SUM(first) from example group by first; +-------+--------+------------+ | first | second | SUM(first) | +-------+--------+------------+ | 1 | 2 | 1 | | 2 | 3 | 2 | +-------+--------+------------+ 2 rows in set (0.00 sec) If it is not obvious, I want the sum of "first," which, by my calculations, should be 3. What am I doing wrong? Thanks! --kevin --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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