使用SQL创建视图:
CREATE VIEW wlview
AS
SELECT TeachID, TeacherName, Term, Workload
FROM teacher
JOIN workload
ON teacher.ID = workload.TeachID
使用SQL创建视图:
CREATE VIEW wlview
AS
SELECT TeachID, TeacherName, Term, Workload
FROM teacher
JOIN workload
ON teacher.ID = workload.TeachID