오라클(Update + Join)

UPDATE/*+ bypass_ujvc */

(

  SELECT a.fund_name t1,fund_rename t2 FROM fund a JOIN FUND_IMSI b

  ON A.FUND = B.FUND

  WHERE fund_rename <> '-' AND fund_rename <> '삭제요망'

) t

SET t1= t2;