UPDATE {테이블명} AS a
JOIN {테이블명} AS b 
ON a.{필드명} = b.{필드명}
SET a.{필드명} = b.{필드명};