sql查询问题
select count(*) as 评论个数,id,(select title from 表1 z where z.ID=a.ID) as 歌曲名from 表2 a having IDorder by count(*)答案补充select count(*) as 评论个数,a.ID,a.title from 表1 a left join 表2 b on a.ID=b.SIDgroup by a.ID,a.titleorder by count(*) desc