Update Join delete JOIN

UPDATE INNER JOIN

UPDATE A SET Name='whq'
FROM TableA AS A
INNER JOIN TableB AS B ON A.ID=B.ID
WHERE A.ID<1000 AND B.Type=2 
DELETE INNER JOIN

DELETE A
 FROM TableA AS A
INNER JOIN TableB AS B ON A.ID=B.ID
WHERE A.ID<1000 AND B.Type=2