UPDATE table a
SET a.field=(a.field+b.subfield)
INNER JOIN (SELECT subid, subfield FROM subtable WHERE ..... ) AS b
ON a.id = b.subid
WHERE ...