Update value from SUM(values) in another table

I recently found myself forgetting the exact syntax to update a ...