Re: SUM in WHERE

[Edward Macnaghten]

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

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]