[mamcx]

Puedes usar JOINS en UPDATE, DELETE e INSERT.

En este caso:

https://www.mysqltutorial.org/mysql-update-join/

Código SQL [-]
UPDATE employees
        INNER JOIN
    merits ON employees.performance = merits.performance 
SET 
    salary = salary + salary * percentage;