select a.name,b.kemu1 from A表 as a ,B表 as b on a.banji_id=b.banji_id where (select count(name) from A表)>1 group by name
那你试试看 能不能先把学了多个科目的人得出来 然后与科目的表连接 我也是新手 多交流select a.id,a.name,b.kemu1 from (select id,name,banji_id from A表 where count(banji_id)>1 group by banji_id) a join B表 a using (banji_id)
select a.name,b.kemu1 from A表 as a ,B表 as b on a.banji_id=b.banji_id where (select count(name) from A表)>1 group by name