SQL query issue

[clifford]

Hi there,

I just recently moved all our stuff from MSSQL to MySQL and I'm glad to report everything went fairly well. I'm having just a few small issues one of them being this SQL query which I can't seem to solve. If anyone can assist I would appreciate it. The MSSQL query is:

SELECT ID, CategoryName, (SELECT COUNT(*) FROM adcontent A INNER JOIN Subcategories S ON A.TopicID=S.ID WHERE S.CategoryID=C.ID ) AS Entries FROM Categories C GROUP BY ID, CategoryName ORDER BY CategoryName

I have tried to get it to work on MySQL without joy. Basically the ouput must be ID, CategoryName and a count as Entries from Categories. Any help would be much appreciated.

Many thanks,
Clifford.