Posted by markc600 on 03/23/06 12:27

UPDATE employment
SET sal=(
SELECT AVG(employee.sal)*2
FROM employee
WHERE employment.managerid=employee.managerid)

[Back to original message]