Check out example codes for "how to reference a table with two foreign key in sql". It will help you in understanding the concepts better.

Code Example 1

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

Learn ReactJs, React Native from