Alter VIEW Tests AS SELECT Dept_Name, EMP1.Emp_Name, EMP2.Emp_Name AS Dept_Boss FROM Dept JOIN EMP EMP1 on Dept_Emp = EMP1.Emp_ID JOIN EMP EMP2 on Dept_Boss = EMP2.Emp_ID