SELECT 로 UPDATE 하기

 UPDATE SEPROJECT_MASTER M SET
            ( M.PROJECT_TYPE   
             ,...)
            =(SELECT
                 TMP.PROJECT_TYPE   
                ,...
               FROM SEPROJECT_TMP TMP
               WHERE TMP.UPLOAD_KEY = #upload_key#
               AND TMP.PROJECT_NAME = #q_prjNm#
            )
        WHERE M.PROJECT_NAME = #q_prjNm#