update table with joins

UPDATE  a

SET a.[Description]= b.[code]

from t1 AS a

INNER JOIN t1 as  b

ON a.TID = b.TID

where b.description='d1'