아래와 같은 outer join을 해야 하는대
DB2에서는 어떻게 해야 하나요??
답변해주시면 감사하겠습니다..
select a.iyulgb as iyulgb
, c.infokorname as iyulgbname
, a.gijunilja as gijunilja
, a.rate as rate
from cmSJRATE A
, (select min(iyulgb) as iyulgb
, max(gijunilja) as gijunilja
from cmSJRATE
group by iyulgb) b
, cmCDINFO c
where a.iyulgb = b.iyulgb
and a.gijunilja = b.gijunilja
and a.iyulgb = c.infocode(+)
|