CREATE VIEW MYPROJECT(projNo, managerLastName, managerFirstName, empId, empLastName, empFirstName)
AS SELECT Project.projNo, PROJMGR.lastName, PROJMGR.firstName, EMP.empId, EMP.lastName, EMP.firstName
FROM Worker PROJMGR, Worker EMP, Assign, Project
WHERE EMP.empId=Assign.empId AND Assign.projNo=Project.projNo AND Project.projMgrId=PROJMGR.empId;