Good day.
I cannot query my MySQL 4.0 database.
When I try to execute:
Code:
SELECT T.NAME, C.CNT
FROM TAGS T
INNER JOIN (
SELECT TAG_ID, COUNT(*) AS CNT
FROM TAGS_FEEDS
GROUP BY TAG_ID
HAVING CNT >=1
) C ON C.TAG_ID = T.ID
I recieve:
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT TAG_ID, COUNT( * ) AS CNT
FROM TAGS_FEEDS GROUP BY T
This query works fine on MySQL 4.1 on the database having same structure. So, why old server cannot execute this query and how should i change it?
Thanks.
dBforums
>
MySQL 4.0: why my SQL syntax wrong?
02-13-06, 12:51
Linear Mode
