Difference between revisions of "Oracle/Update join"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
<source lang=" | <source lang="oracle11"> | ||
UPDATE (SELECT b.bonus, e.salary | UPDATE (SELECT b.bonus, e.salary | ||
FROM employee_bonus b | FROM employee_bonus b | ||
Revision as of 09:43, 7 December 2009
UPDATE (SELECT b.bonus, e.salary
FROM employee_bonus b
JOIN employees e ON b.employee_id = e.employee_id
WHERE e.bonus_eligible = 1) t
SET t.bonus = 0.1 * t.salary;