Did you know ... Search Documentation:
Arithmetic UPDATE with an INNER JOIN and a WHERE restriction