MERGE INTO tmp_cm_post_t a USING ( SELECT a.rid , b.bubjung_cd FROM (SELECT ROWID rid , bubjung_cd , post_sido || REPLACE(post_sigun, ' ', '') || post_dong || post_ri AS bub_nm FROM tmp_cm_post_t ) a , (SELECT bubjung_cd, hangjung_sd_nm || CASE WHEN SUBSTR(bubjung_cd, 6, 5) = '00000' THEN REPLACE(hangjung_sk_nm,' ', '') ELSE REPLACE(hangjung_sk_nm,' ', '') || CASE WHEN SUBSTR(bubjung_cd, 9, 2) = '00' THEN bubjung_nm ELSE HANGJUNG_up_nm || bubjung_nm END END AS bub_nm FROM tmp_cm_post_bubhang ) b WHERE a.bub_nm = b.bub_nm AND b.bubjung_cd IS NOT NULL ) b ON (a.ROWID = b.rid) WHEN MATCHED THEN UPDATE SET bubjung_cd = b.bubjung_cd ;