--1.
Select NAME_NO,NAME from JOINTEST_SELF;


--2.
col "A当番" FOR a6
col "B当番" FOR a6
col "当番A" FOR a6
col "当番B" FOR a6
Select T1.NAME A当番,T2.NAME B当番
 FROM	JOINTEST_SELF T1,
		JOINTEST_SELF T2;


--3.
col "A当番" FOR a6
col "B当番" FOR a6
col "当番A" FOR a6
col "当番B" FOR a6
Select T1.NAME A当番,T2.NAME B当番
 FROM	JOINTEST_SELF T1,
		JOINTEST_SELF T2
 WHERE	T1.NAME_NO <> T2.NAME_NO;


--4.
col "A当番" FOR a6
col "B当番" FOR a6
col "当番A" FOR a6
col "当番B" FOR a6
Select T1.NAME 当番A,T2.NAME 当番B
 FROM	JOINTEST_SELF T1,
		JOINTEST_SELF T2
 WHERE	T1.NAME_NO > T2.NAME_NO
 ORDER BY T1.NAME_NO;