求解

Question

在线，急

Answer 1

USE teaching2;
CREATE  OR REPLACE VIEW `student_course_sc` AS
    SELECT 
       student.sno,student.sname,student.course,student.cno,student.score
    FROM
        student,sc
where
student.sno=sc.sno;