CREATE VIEW Employee AS
SELECT P.SSN as SSN, Name, Address,
Birthdate, EmployeeID, Department, Salary
FROM Person P
left join EmployeeTable E on p.ssn = e.ssn
SELECT P.SSN as SSN, Name, Address,
Birthdate, EmployeeID, Department, Salary
FROM Person P
left join EmployeeTable E on p.ssn = e.ssn
SELECT P.SSN as SSN, Name, Address,
Birthdate, EmployeeID, Department, Salary
FROM Person P
left outer join EmployeeTable E on p.ssn = e.ssn