Is there any reason that you need to "sum" the id? I'm assuming that you're trying to "count". Ya?
-----Original Message----- From: Noamn [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 5:22 PM To: [EMAIL PROTECTED] Subject: 'Sum' syntax I'm using v3.23.51 on Linux. Can anyone explain why a simple 'sum' select won't work?? Here is the example: mysql> select sum (id), pet from visits group by pet; ERROR 1064: You have an error in your SQL syntax near '(id), pet from visits group by pet' at line 1 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]