SELECT *,
(SELECT T_User_Music_SpecialList.Special_Name
FROM T_User_Music_SpecialList
WHERE (T_User_Music_SpecialList.Special_ID = T_User_MusicList.Special_ID))
AS SpecialName,
(SELECT COUNT(T_User_BlogReView.ReView_ID) AS COUNT
FROM T_User_BlogReView
WHERE (T_User_BlogReView.reView_ID = T_User_MusicList.Song_id) AND
T_User_BlogReView.Blog_Type = 'Music')
FROM T_User_MusicList
3个表,音乐表、评论表、专辑表
要得到音乐表的全部资料和专辑名以及他有多少条评论,谢谢!
(SELECT T_User_Music_SpecialList.Special_Name
FROM T_User_Music_SpecialList
WHERE (T_User_Music_SpecialList.Special_ID = T_User_MusicList.Special_ID))
AS SpecialName,
(SELECT COUNT(T_User_BlogReView.ReView_ID) AS COUNT
FROM T_User_BlogReView
WHERE (T_User_BlogReView.reView_ID = T_User_MusicList.Song_id) AND
T_User_BlogReView.Blog_Type = 'Music')
FROM T_User_MusicList
3个表,音乐表、评论表、专辑表
要得到音乐表的全部资料和专辑名以及他有多少条评论,谢谢!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货