--1.
Select	JOINTEST_NAME.NAME_NO,
		JOINTEST_NAME.NAME,
		JOINTEST_GENDER.GEND_CODE,
		JOINTEST_GENDER.GENDER
 from JOINTEST_NAME
 INNER JOIN JOINTEST_GENDER
 ON JOINTEST_NAME.GEND_CODE=JOINTEST_GENDER.GEND_CODE;



--2.
Select	JOINTEST_NAME.NAME_NO,
		JOINTEST_NAME.NAME,
		JOINTEST_GENDER.GEND_CODE,
		JOINTEST_GENDER.GENDER
 from JOINTEST_NAME
 JOIN JOINTEST_GENDER
 ON JOINTEST_NAME.GEND_CODE=JOINTEST_GENDER.GEND_CODE;



--3.
Select	JOINTEST_NAME.NAME_NO,
		JOINTEST_NAME.NAME,
		GEND_CODE,
		JOINTEST_GENDER.GENDER
 from JOINTEST_NAME
 JOIN JOINTEST_GENDER
 USING(GEND_CODE);



--4.
Select	JOINTEST_NAME.NAME_NO,
		JOINTEST_NAME.NAME,
		JOINTEST_GENDER.GEND_CODE,
		JOINTEST_GENDER.GENDER
 from JOINTEST_NAME
 LEFT OUTER JOIN JOINTEST_GENDER
 ON JOINTEST_NAME.GEND_CODE=JOINTEST_GENDER.GEND_CODE;



--5.
Select	JOINTEST_NAME.NAME_NO,
		JOINTEST_NAME.NAME,
		JOINTEST_GENDER.GEND_CODE,
		JOINTEST_GENDER.GENDER
 from JOINTEST_NAME
 LEFT JOIN JOINTEST_GENDER
 ON JOINTEST_NAME.GEND_CODE=JOINTEST_GENDER.GEND_CODE;



--6.
Select	JOINTEST_NAME.NAME_NO,
		JOINTEST_NAME.NAME,
		GEND_CODE,
		JOINTEST_GENDER.GENDER
 from JOINTEST_NAME
 LEFT JOIN JOINTEST_GENDER
 USING(GEND_CODE);



--7.
Select	JOINTEST_NAME.NAME_NO,
		JOINTEST_NAME.NAME,
		JOINTEST_GENDER.GEND_CODE,
		JOINTEST_GENDER.GENDER
 from JOINTEST_NAME
 RIGHT OUTER JOIN JOINTEST_GENDER
 ON JOINTEST_NAME.GEND_CODE=JOINTEST_GENDER.GEND_CODE;



--8.
Select	JOINTEST_NAME.NAME_NO,
		JOINTEST_NAME.NAME,
		JOINTEST_GENDER.GEND_CODE,
		JOINTEST_GENDER.GENDER
 from JOINTEST_NAME
 RIGHT JOIN JOINTEST_GENDER
 ON JOINTEST_NAME.GEND_CODE=JOINTEST_GENDER.GEND_CODE;



--9.
Select	JOINTEST_NAME.NAME_NO,
		JOINTEST_NAME.NAME,
		GEND_CODE,
		JOINTEST_GENDER.GENDER
 from JOINTEST_NAME
 RIGHT JOIN JOINTEST_GENDER
 USING(GEND_CODE);




--10.
Select	JOINTEST_NAME.NAME_NO,
		JOINTEST_NAME.NAME,
		JOINTEST_GENDER.GEND_CODE,
		JOINTEST_GENDER.GENDER
 from JOINTEST_NAME
 FULL OUTER JOIN JOINTEST_GENDER
 ON JOINTEST_NAME.GEND_CODE=JOINTEST_GENDER.GEND_CODE;



--11.
Select	JOINTEST_NAME.NAME_NO,
		JOINTEST_NAME.NAME,
		JOINTEST_GENDER.GEND_CODE,
		JOINTEST_GENDER.GENDER
 from JOINTEST_NAME
 FULL JOIN JOINTEST_GENDER
 ON JOINTEST_NAME.GEND_CODE=JOINTEST_GENDER.GEND_CODE;



--12.
Select	JOINTEST_NAME.NAME_NO,
		JOINTEST_NAME.NAME,
		GEND_CODE,
		JOINTEST_GENDER.GENDER
 from JOINTEST_NAME
 FULL JOIN JOINTEST_GENDER
 USING(GEND_CODE);



--13.
Select	NAME_NO,
		NAME,
		GEND_CODE,
		GENDER
 from JOINTEST_NAME
 NATURAL JOIN JOINTEST_GENDER;



--14.
Select	NAME_NO,
		NAME,
		GEND_CODE,
		GENDER
 from JOINTEST_NAME
 NATURAL LEFT JOIN JOINTEST_GENDER;



--15.
Select	NAME_NO,
		NAME,
		GEND_CODE,
		GENDER
 from JOINTEST_NAME
 NATURAL RIGHT JOIN JOINTEST_GENDER;



--16.
Select	JOINTEST_NAME.NAME_NO,
		JOINTEST_NAME.NAME,
		JOINTEST_GENDER.GEND_CODE,
		JOINTEST_GENDER.GENDER
 from JOINTEST_NAME
 CROSS JOIN JOINTEST_GENDER;



--17.
Select	JOINTEST_NAME.NAME_NO,
		JOINTEST_NAME.NAME,
		JOINTEST_GENDER.GEND_CODE,
		JOINTEST_GENDER.GENDER
 from 	JOINTEST_NAME,
 		JOINTEST_GENDER;