关于SQL中两张表联合sum和group by的查询问题

select a.name name, sum(a.count) count from 表A a, 表B b whete a.type = b.type group by b.name