34,590
社区成员
发帖
与我相关
我的任务
分享
select a.id,a.nam,b.logcount from
(select id,name from a) a
left join
(select name,count(loge) as logcount form b group by name) b
on a.name=b.name
select a.id,a.nam,b.logcount from
(select id,name from a) a
left join
(select name,count(loge) as logcount form b) b
on a.name=b.name
with userdb(id,name) as (
select 1 ,'张三' union all
select 2 ,'李四' union all
select 3 ,'王五'
)
, log(id ,name,logdate) as
(
select 1, '张三', '20200101' union all
select 2, '李四', '20201201' union all
select 3, '张三', '20200102'
)
select t1.name,count(t2.name) as log_count
from userdb t1
left join log t2 on t1.name=t2.name
group by t1.name
结果:
name log_count
张三 2
李四 1
王五 0
select t1.PeopleName,count(t2.PeopleName) from Table1 t1 left join Table2 t2 on t1.PeopleName=t2.PeopleName group by t1.PeopleName