Hello
The following query used to work when I was using an Access database, but
now that I've moved to MySQL I get a syntax error when I try and run it:
SELECT *, (SELECT COUNT (*)
FROM Links
WHERE Links.CAT_ID = Categories.CAT_ID AND LINK_APPROVED = 'Yes') AS
LINK_COUNT FROM Categories
ORDER
Trevor Sather wrote:
Hello
The following query used to work when I was using an Access database,
but now that I've moved to MySQL I get a syntax error when I try and
run it:
SELECT *, (SELECT COUNT (*)
FROM Links
WHERE Links.CAT_ID = Categories.CAT_ID AND LINK_APPROVED = 'Yes') AS