【正文】
根據(jù)連接操作定義視圖。CREATE VIEW Employee_Departments_Salary_View(Name, Department, Salary) AS SELECT , FROM Employee a, Departments b, Salary c WHERE = AND = 。 舉例:定義一個比所有財務部的雇員工資都高的雇員的信息的視圖 CREATE VIEW Employee_Salary_View AS SELECT * FROM Employee WHERE EmployeeID IN( SELECT EmployeeID FROM Salary