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]