Equiv-Join 과 Outer-Join

Equiv-Join 과 Outer-Join
(Oracle /MS AccDB SQL 비교)

1. EQUIV JOIN ( --- --- )

 Oracle
FROM   tb_art_car_credt
     , tb_art_cartype_cd
WHERE  tb_art_car_credt.car_kind_cd = tb_art_cartype_cd.car_kind_cd

 AccDB
FROM
TSLTIS_TB_ART_CAR_CREDT INNER JOIN TSLTIS_TB_ART_CARTYPE_CD
ON
TSLTIS_TB_ART_CAR_CREDT.CAR_KIND_CD = TSLTIS_TB_ART_CARTYPE_CD.CAR_KIND_CD

2. LEFT OUTER JOIN ( --＋ --→ )

 Oracle
FROM   tb_art_car_credt
     , tb_art_cartype_cd
WHERE  tb_art_car_credt.car_kind_cd = tb_art_cartype_cd.car_kind_cd(+)

 AccDB
FROM
TSLTIS_TB_ART_CAR_CREDT LEFT JOIN TSLTIS_TB_ART_CARTYPE_CD
ON
TSLTIS_TB_ART_CAR_CREDT.CAR_KIND_CD = TSLTIS_TB_ART_CARTYPE_CD.CAR_KIND_CD

3. RIGHT OUTER JOIN ( ＋--  ←-- )

 Oracle
FROM   tb_art_car_credt
     , tb_art_cartype_cd
WHERE  tb_art_car_credt.car_kind_cd(+) = tb_art_cartype_cd.car_kind_cd

 AccDB
FROM
TSLTIS_TB_ART_CAR_CREDT RIGHT JOIN TSLTIS_TB_ART_CARTYPE_CD
ON
TSLTIS_TB_ART_CAR_CREDT.CAR_KIND_CD = TSLTIS_TB_ART_CARTYPE_CD.CAR_KIND_CD