RIGHT OUTER JOIN????????????JOIN??????????????????????????????JOIN???????????????????????? ???????????????????????????(???)????????????????????????????????????(???)??????????????????????????????????????????????????????????????????????????????????????????NULL?????????????????????A LEFT OUTER JOIN B ??? B RIGHT OUTER JOIN A??????????????????????????????????????????????????????
?????? RIGHT [ OUTER ] JOIN ?????? { ON ????????? }
ON???????????????????????????????????????????????????SELECT??????????????????????????????????????? ON????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????(??????????????????????????????????????????)
-- ????????????????????????????????? -- ????????????????????????????????????????????? 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'
-- ????????????????????????????????? -- ?????????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