student表 student_b表 查出student表与student_b表中type值相同的记录,并按照student表中type字段进行分组 SELECT DISTINCT * FROM student a ,student_b b WHERE a.`type`=b.`type` GROUP BY a.type; 查询结果: