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)
UPDATE tabela y
SET campo = (select campo
FROM xxxxxx z
WHERE z.chave = y.chave)
WHERE .... ( retorna as 3545 linhas)
Usuários navegando neste fórum: Nenhum usuário registrado e 3 visitantes