update tablea A set A.a = (select B.a from tableb B where A.key = B.key) where exists (select 1 from tableb B where B.key = A.key)