【正确答案】要在成绩表Student_course中修改成绩,但是姓名在学生表Students中,课程名在课程表Courses中,所以在UPDATE语句中需要用到FROM子句。语句如下。
USE Student
UPDATE Student_course
SET Student grade=88
FROM Students AS ST
INNER JOIN Student_course AS SC
ON SC Student_id=ST.Student_id
INNER JOIN Courses AS CS
ON CS.Course_id=SC.Course id
WHERE CS.Course_name='电子商务基础'AND ST.Student_name='叶海平'
【答案解析】