UPDATE 쿼리문

 

 

-- 글 작성 대기

UPDATE EMPLOYEE
SET NAME = E1.NAME
FROM EMPLOYEE [E]
LEFT JOIN DI_USER [E1] on E1.ID = E.ID