SELECT a.cust, a.cust_name, a.address, b.tel_num, c.rate_name, d.vol_name

FROM tcust_master a, tcust_telnum b, tcust_rate_hist_jk c, tcust_volume_hist_jk d

WHERE a.cust = b.cust

        and a.cust = c.cust(+)

        and a.cust = d.cust(+)

       and c.rate_update =

      (select max(rate_update) from tcust_rate_hist_jk) and d.vol_update = (select max(vol_update) from        tcust_volume_hist_jk);

현재 이런식으로 업데이트 하니까 hist가 있는 데이터만 출력이 되는데..

나머지도 출력이 되게 하고싶어요.. (hist가 없는 데이터..)

도움 부탁드립니다.

SELECT a.cust_name, a.address, b.tel_num, c.rate_name, d.vol_name
  FROM tcust_master a
     , tcust_telnum b
     , (SELECT cust
             , MAX(rate_name)
               KEEP(DENSE_RANK LAST ORDER BY rate_update) rate_name
          FROM tcust_rate_hist_jk
         GROUP BY cust
        ) c
     , (SELECT cust
             , MAX(vol_name)
               KEEP(DENSE_RANK LAST ORDER BY vol_update) vol_name
          FROM tcust_volume_hist_jk
         GROUP BY cust
        ) d
 WHERE a.cust = b.cust
   AND a.cust = c.cust(+)
   AND a.cust = d.cust(+)
;

마농님 댓글 정말 감사합니다.!!