Hi many thanks for the help :)
On Apr 14, 2012, at 6:21 PM, Stefan Kuhn wrote:
> On Saturday 14 April 2012 09:51:11 Willy Mularto wrote:
>> Please help what is wrong with this simple query "SELECT COUNT(key_agent)
>> total FROM agents_consolidated WHERE total = 180" Thanks.
> You need to use having instead of where, see the documentation.
>> Willy Mularto
>> F300HD+MR18DE (NLC1725)
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql