22,209
社区成员
发帖
与我相关
我的任务
分享
select a.*,b.newscount from userlist a,
(select adduser,newscount=count(*) from news group by adduser)b
where a.username=b.adduser
SELECT A.USERNAME, COUNT(B.*) AS NEWSCOUNT
FROM USERLIST A LEFT JOIN NEWS B
ON A.USERNAME = B.ADDUSER
GROUP BY A.USERNAME
select a.*,b.newscount
from userlist a left join
(select adduser,count(*) as newscount from news group by adduser)b
on a.username=b.adduser
SELECT A.*,B.NEWSCOUNT FROM A LEFT JOIN B ON A.USERNAME = B.ADDUSER