【文章內(nèi)容簡介】
epartment, Salary) AS SELECT , FROM Employee a, Departments b, Salary c WHERE = AND = 。5)基于多個(gè)表根據(jù)嵌套查詢定義視圖。 舉例:定義一個(gè)比所有財(cái)務(wù)部的雇員工資都高的雇員的信息的視圖 CREATE VIEW Employee_Salary_View AS SELECT * FROM Employee WHERE EmployeeID IN( SELECT EmployeeID FROM Salary WHERE Ine ALL( SELECT Ine FROM Salary WHER