在线,急

解决方案 »

  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;