D AND L.LINK_APPROVED='Yes')
GROUP BY C.CAT_ID
ORDER BY CAT_NAME
Hope that helps.
Matt
- Original Message -
From: "Trevor Sather"
Sent: Thursday, October 23, 2003 6:49 PM
Subject: Syntax for SQL Query - used to work with Access
> Hi
>
> This query used to work w
Hi
This query used to work with an Access database:
SELECT *, (SELECT COUNT (*) FROM Links WHERE Links.CAT_ID =
Categories.CAT_ID AND LINK_APPROVED = 'Yes') AS LINK_COUNT FROM
Categories ORDER BY CAT_NAME ASC
Now that we've upgraded to MySQL, the same ASP script returns this
error:
ADO
