“It is easier to go down a hill than up it, but the view is much better at the top.”
Creating a Simple View
CREATE View Employee_V AS
The purposes of views are to restrict access to certain columns, derive columns or Join Tables, and to restrict access to certain rows (if a WHERE clause is used).
Basic Rules for Views
CREATE View Department_Salaries AS
SELECT Dept_No ...