PPT Slide

joined from multiple tables in addition to

all the features of simple views, such as

using order by in the select statement

that creates the view.

CREATE VIEW employee_view AS (SELECT e.empid empid,

e.lastname lastname,

e.firstname firstname, e.salary salary,

a.address,

a.city,

a.state, a.zipcode FROM employee e, employee_address a WHERE e.empid = a.empid);