how to reference a table with two foreign key in sql site:stackoverflow.com
snippet in sql

how to reference a table with two foreign key in sql site:stackoverflow.com

user1761

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