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