wzydf:
那么如何解决?仿佛in,exists也出错
[阅读: 308] 2005-08-02 04:05:55
SELECT comment_post_ID, count( * ) AS fc
FROM evo_comments
GROUP BY comment_post_id
以上可以,但如果写成select * from evo_posts a where a.ID in( SELECT comment_post_ID, count( * ) AS fc
FROM evo_comments
GROUP BY comment_post_id)
就会出错