I tried it also with 5.0.24-community-nt and it still didn't work! Randall Price
Microsoft Implementation Group Secure Enterprise Computing Initiatives Virginia Tech Information Technology 1700 Pratt Drive Blacksburg, VA 24060 Email: [EMAIL PROTECTED] Phone: (540) 231-4396 -----Original Message----- From: Ahmad Al-Twaijiry [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 19, 2006 10:06 AM To: Edward Macnaghten Cc: mysql@lists.mysql.com Subject: Re: SUM in WHERE I tried it also with 4.1.21-log and still didn't work ! On 9/19/06, Ahmad Al-Twaijiry <[EMAIL PROTECTED]> wrote: > I tried that before and it also doesn't work, is it because I'm using > mysql version 4.1.19 ? > > On 9/19/06, Edward Macnaghten <[EMAIL PROTECTED]> wrote: > > Ahmad Al-Twaijiry wrote: > > > > > Hi everyone > > > > > <snip> > > > > > SELECT * FROM tbl_name WHERE SUM(Total)=100 ORDER BY ID > > > > > > > > > > SELECT ID FROM tbl_name GROUP BY ID HAVING SUM(Total)=100 ORDER BY ID > > > > > > -- > > Ahmad Fahad AlTwaijiry > -- Ahmad Fahad AlTwaijiry -- 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]