--1.
Select T1.NAME_NO,T1.NAME,T1.BOSS,T2.NAME
From JOINTEST_SELF T1
INNER JOIN JOINTEST_SELF T2
ON T1.BOSS=T2.NAME_NO;



--2.
Select T1.NAME_NO,T1.NAME,T1.BOSS,T2.NAME
From JOINTEST_SELF T1
LEFT JOIN JOINTEST_SELF T2
ON T1.BOSS=T2.NAME_NO;



--3.
Select T1.NAME_NO,T1.NAME,T1.BOSS,T2.NAME
From JOINTEST_SELF T1
RIGHT JOIN JOINTEST_SELF T2
ON T1.BOSS=T2.NAME_NO;



--4.
Select T1.NAME_NO,T1.NAME,T1.BOSS,T2.NAME
From JOINTEST_SELF T1
FULL JOIN JOINTEST_SELF T2
ON T1.BOSS=T2.NAME_NO;