Se va actualiza tabelul COPY_EMP pe baza valorilor din tabelul EMPLOYEES
UPDATE copy_emp
SET department_id= (SELECT department_id
FROM employees
WHERE employee_id =100)
WHERE job_id= (SELECT job_id
FROM employees
WHERE employee_id =200);