------=_NextPart_000_ 004D_01C3456C.6 6EFEC50
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
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 BY CAT_NAME ASC
The error message is this:
SQLState: 42000
Native Error Code: 1064
[TCX][MyODBC]syntax error near 'SELECT COUNT (*) FROM Links WHERE
Links.CAT_ID = Categories.CAT_ ID AND LINK_AP' at line 1
Any immediate reactions? Thanks in advance for any help you can give me...
Best wishes
Trevor Sather
------=_NextPart_000_ 004D_01C3456C.6 6EFEC50--
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
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 BY CAT_NAME ASC
The error message is this:
SQLState: 42000
Native Error Code: 1064
[TCX][MyODBC]syntax error near 'SELECT COUNT (*) FROM Links WHERE
Links.CAT_ID = Categories.CAT_ ID AND LINK_AP' at line 1
Any immediate reactions? Thanks in advance for any help you can give me...
Best wishes
Trevor Sather
------=_NextPart_000_ 004D_01C3456C.6 6EFEC50--