Update Join delete JOIN

?

1 2 3 4 5 6 7 8 9 10 11 12

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