RIGHT OUTER JOIN ??????

RIGHT OUTER JOIN????????????JOIN??????????????????????????????JOIN???????????????????????? ???????????????????????????(???)????????????????????????????????????(???)??????????????????????????????????????????????????????????????????????????????????????????NULL?????????????????????A LEFT OUTER JOIN B ??? B RIGHT OUTER JOIN A??????????????????????????????????????????????????????

??????

?????? RIGHT [ OUTER ] JOIN ??????
{
    ON ????????? 
    }

ON???????????????????????????????????????????????????SELECT??????????????????????????????????????? ON????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????(??????????????????????????????????????????)

???1

-- ?????????????????????????????????
-- ?????????????????????????????????????????????

SELECT COUNTRIES.COUNTRY, CITIES.CITY_NAME 
FROM CITIES 
RIGHT OUTER JOIN COUNTRIES 
ON CITIES.COUNTRY_ISO_CODE = COUNTRIES.COUNTRY_ISO_CODE

-- ?????????????????????????????????
-- ????????????????????????????????????????????????????????????

SELECT COUNTRIES.COUNTRY, CITIES.CITY_NAME
FROM CITIES 
RIGHT OUTER JOIN COUNTRIES 
ON CITIES.COUNTRY_ISO_CODE = COUNTRIES.COUNTRY_ISO_CODE
WHERE Countries.region = 'Africa'

-- RIGHT JOIN??????????????????????????????????????????
-- ???????????????????????????????????????
SELECT COUNTRIES.COUNTRY, CITIES.CITY_NAME
FROM CITIES 
RIGHT JOIN COUNTRIES 
ON CITIES.COUNTRY_ISO_CODE = COUNTRIES.COUNTRY_ISO_CODE
WHERE Countries.region = 'Africa'

???2

-- ?????????????????????????????????
-- ?????????FRON?????????????????????????????????????????????????????????
-- ?????????????????????????????????????????????????????????
-- ???????????????????????????????????????????????????????????????????????????

SELECT E.EMPNO, E.LASTNAME, M.EMPNO, M.LASTNAME	
	FROM EMPLOYEE E RIGHT OUTER JOIN	
	DEPARTMENT RIGHT OUTER JOIN EMPLOYEE M 
        ON MGRNO = M.EMPNO
        ON E.WORKDEPT = DEPTNO