How do I update a col in table A, using info From table B

2018-07-03 23:46:12

This question already has an answer here:

How can I do an UPDATE statement with JOIN in SQL? 14 answers

细节上很稀疏，但是像这样的东西应该让你关闭。

Update A
set IsDeleted = 1
from TableA A
join TableB B on b.ItemNumber = A.ItemNumber
where b.OrderNumber > 'XY004005'
and b.OrderNumber < 'XY500000'

链接地址: http://www.djcxy.com/p/94664.html