56,677
社区成员
发帖
与我相关
我的任务
分享
select 姓名, sum(表1记录数) as 表1记录数, sum(表2记录数) as 表2记录数,
sum(表1记录数) + sum(表2记录数) as 总记录数
from(
select 姓名, count(*) as 表1记录数, 0 as 表2记录数 from tb1 group by 姓名
union all
select 姓名, 0 as 表1记录数, count(*) as 表2记录数 from tb2 group by 姓名
) a
group by 姓名