显示学生号,成绩等: 如图,三张表: mysql查询语句: select s.no,name,subname,score from stu s inner join score sc on s.no=sc.no LEFT JOIN sub sb on sc.subno=sb.subno; 结果: