GROUP BY returns 0 records

[Bubah]

This query:

SELECT p.Path, p.Title, COUNT(s.ID) AS Total FROM Stats AS s, Paths AS p
WHERE s.ID=p.ID AND s.Stamp = '2002-10-03' GROUP BY Path,Title ORDER BY
Total DESC LIMIT 10

Returns 0 records. When I remove the COUNT(s.ID) and GROUP BY clause, it
works fine. Why can't I get the GROUP BY and COUNT to work. Is there a bug
in MySQL?

DB INFO:

DBMS Version: 3.23.46-nt
OLE DB Version: 02.00
Provider Name: MSDASQL.DLL
Provider Version: 02.60.6526.0
Provider Friendly Name: Microsoft OLE DB Provider for ODBC Drivers
Driver Name: myodbc.dll
Driver Version: 2.50.39
Driver ODBC Version: 02.50


Thanks.

 

[petersJazz]

Try count(*)

 

[Bubah]

I've tried COUNT(*) and still I get 0 records. No error, just no records.