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:
>> Hi,
>> 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.
> Stefan
>>
>>
>>
>> Willy Mularto
>> F300HD+MR18DE (NLC1725)
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql
>
Willy Mularto
F300HD+MR18DE (NLC1725)
