Create View (SQL)

To create a new view, we use the following syntax:

CREATE VIEW WORKS_ON1 AS
SELECT name, pname, hours
FROM   EMPLOYEE, PROJECT, WORKS_ON
WHERE  ssn=essn
  AND  pno=pnumber