Mysql多表联查,大神们来帮帮忙,很着急!!!!!!!!!

Question

现有三张表
teacher表:
id name

1 大炮
2 机枪
3 老师

grade表:
id gradename
1 小班
2 大班
3 中班

grade_teacher表:
id gradeid teacherid
1 1 1
2 2 1
3 3 1

最后这张是关系表,意思就是一个老师可能给很多的班级上课,现在就是想把这个一个老师给那些班级上课查询出来

呼叫各位大神! 这个该怎么写

Answer 1

 select teacher.name,grade.gradename from teacher inner join grade inner join grade_teacher as gd where teacher.id = gd.teacherid and grade.id = gd.gradeid  groupBy gd.teacherid

分组查询