아시아 지역에 근무하는 직원의 보너스를 0.3으로 변경
SELECT EMP_ID, EMP_NAME, DEPT_TITLE, LOCAL_NAME, BONUS
FROM EMPLOYEE2
LEFT JOIN DEPARTMENT ON(DEPT_CODE = DEPT_ID)
JOIN LOCATION ON(LOCATION_ID = LOCAL_CODE)
WHERE LOCAL_NAME LIKE 'ASIA%';
UPDATE EMPLOYEE2
SET BONUS = 0.3
WHERE EMP_ID IN(SELECT EMP_ID
FROM EMPLOYEE2
LEFT JOIN DEPARTMENT ON(DEPT_CODE = DEPT_ID)
JOIN LOCATION ON(LOCATION_ID = LOCAL_CODE)
WHERE LOCAL_NAME LIKE 'ASIA%');
서브쿼리를 사용할 때는 메인쿼리와 서브쿼리를 나누어 생각해 보기!