CREATE VIEW is_s(Sno, Sname, Grade) AS SELECT
student.sno,
sname,
grade
FROM
student,
sc
WHERE
student.sno = sc.sno
AND sdept = 'IS'
AND cno = '1'
10. 建立信息系(IS)选修了1号课程的学生的视图(包括学号、姓名、成绩)
最新推荐文章于 2024-05-11 18:00:04 发布
CREATE VIEW is_s(Sno, Sname, Grade) AS SELECT
student.sno,
sname,
grade
FROM
student,
sc
WHERE
student.sno = sc.sno
AND sdept = 'IS'
AND cno = '1'