视图

CREATE VIEW [User](name,password,quxi)
    AS 
    select Student.StudentName,Student.PassWord,Student.QuXi from Student
    union
    select Teacher.TeacherName,Teacher.PassWord,Teacher.QuXi from Teacher
    union
    select Manager.ManagerName,Manager.PassWord,Manager.QuXi from Manager;

SELECT * FROM [User]