内部连接与MySQL中的3个表

几乎正确..查看联接，您引用的字段错误

SELECt student.firstname,       student.lastname,       exam.name,       exam.date,       grade.grade  FROM grade INNER JOIN student ON student.studentId = grade.fk_studentId INNER JOIN exam ON exam.examId = grade.fk_examId ORDER BY exam.date