oracle三表联查update

MERGE INTO ext_return_zero_positioning t1
USING (
    SELECT t2.target_id, t3.secret_code,ROW_NUMBER() OVER (PARTITION BY source_id ORDER BY version_id DESC) AS rn 
    FROM ext_zero_positioning_link t2
   left JOIN ext_qlty_return_zero_confirm t3 ON t2.source_id = t3.version_id
) s
ON (t1.version_id = s.target_id and s.rn=1)
WHEN MATCHED THEN
  UPDATE SET t1.secret_code = s.secret_code;