主题：分组查询后再left join要如何写

测试没问题

select * from (select 第一列,count(*) from {表B} group by 第一列) as a left join (select 第一列,count(*) from {表C} group by 第一列) as b on a.第一列 = b.第一列

 只能这样写。