select
jx
,sum(case when lx ='a' then 1 else 0 end) as '类型a'
,sum(case when lx ='b' then 1 else 0 end) as '类型b'
,sum(case when lx ='c' then 1 else 0 end) as '类型c'
,sum(case when lx ='d' then 1 else 0 end) as '类型d'
from table1 a inner join table2 b on a.jh = b.jh
group by jx