SELECT studentName AS 学生姓名,subjectName AS 课程名,studentResult AS 成绩 FROM
student INNER JOIN result ON student.`studentNo`=result.`studentno` #student连第一张表
INNER JOIN subject ON result.`subjectno`=subject.`subjectno` #student连第二张表
WHERE subject.`subjectno`=(SELECT subjectNO FROM SUBJECT WHERE subjectName='Logic Java')
student INNER JOIN result ON student.`studentNo`=result.`studentno` #student连第一张表
INNER JOIN subject ON result.`subjectno`=subject.`subjectno` #student连第二张表
WHERE subject.`subjectno`=(SELECT subjectNO FROM SUBJECT WHERE subjectName='Logic Java')