一个 sql 语句查询两个边的内容

来源：百度知道编辑：UC知道时间：2024/06/04 03:21:34

现有两个表user(userid,name),comment(id,title,comment,userid)，用一个sql 语句，查询出 uname 以及该用户名下的 comment 的数量？？？

select u.Name as uname,count(c.ID) as comment数量
from users u left join comment c on u.userid=c.userid

where user.userid=comment.userid

select user.name,count(*) from comment,user where user.uderid=comment.userid

select a.name,count(b.*) as sl from [user] a,[comment] b where a.userid=b.userid

SELECT U.*,(SELECT COUNT(C.id) FROM comment C WHERE C.userid=U.id) as 数量 FROM user U

一个 sql 语句 查询两个边的内容