Difference between revisions of "Oracle/Update join"
Jump to navigation
Jump to search
(New page: <source lang="oracle8"> 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 ...) |
|||
| Line 6: | Line 6: | ||
SET t.bonus = 0.1 * t.salary; | SET t.bonus = 0.1 * t.salary; | ||
</source> | </source> | ||
[[Category:Oracle]] | |||
Revision as of 14:22, 2 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;