UPDATE
employee
SET
salary_amount=salary_amount * 1.10
WHERE
employee.department_number = department.department_number
AND
department_name LIKE '%Support%'
; Note: In an update, you can't use the ON clause, so the join condition is specified in the WHERE clause.
