1 of 3

Could you try this query:

UPDATE TableA AS A 
SET A.indicator = B.indicator 
FROM TableB AS B
WHERE B.type = A.type