Delete and Update

DELETE A FROM Attachment A

INNER JOIN Material M ON A.MatID=M.MatID

WHERE M.AtrID=5

UPDATE A SET Name='附件一'

FROM Attachment A

INNER JOIN Material M ON A.MatID=M.MatID

WHERE M.AtrID=1