UPDATE ~ SET ~ FROM ~ INNER JOIN 구문

UPDATE ~ SET ~ FROM ~ INNER JOIN 구문

UPDATE emailFormat 
SET format=2 
FROM emailFormat EF
INNER JOIN user U ON EF.userID = U.userID