1. LEFT OUTER JOIN
SELECT A.COUNTRY_NM, B.CURRENCY_CD, B.CURRENCY_NM
FROM AC_COUNTRY AS A
LEFT OUTER JOIN AC_CURRENCY AS B
ON B.COUNTRY_CD=A.COUNTRY_CD
2. RIGHT OUTER JOIN
SELECT A.COUNTRY_NM, B.CURRENCY_CD, B.CURRENCY_NM
FROM AC_COUNTRY AS A
RIGHT OUTER JOIN AC_CURRENCY AS B
ON B.COUNTRY_CD=A.COUNTRY_CD
==========================================================================================
** 이 글이 도움이 되셨다면~ 블로그 위 아래로 있는거... 아시죠??? ^^
