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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]