请教如何更新我的这2个表

[gyl086]

aa表
bb表

我的条件是这样的
SUBSTRING(aa.TrainSerial,8,7)=bb.TrainSerial and aa.TrainIdentification='H' and bb.TrainSerial>0 and bb.yesno=0

如果符合这个条件,就把bb表的yesno改成1


请教各位老师们,看看我怎么才能实现这样的目的,谢谢啦

[听雨停了]

--最好先select一下，没有问题再update
--select * 
update b set b.yesno=1
from bb as b
inner join aa as a on SUBSTRING(a.TrainSerial,8,7)=b.TrainSerial and b.TrainSerial>0
and b.yesno=0
where a.TrainIdentification='H'

[唐诗三百首]

update bb
 set yesno=1
 from bb
 inner join aa on substring(aa.TrainSerial,8,7)=bb.TrainSerial 
                  and aa.TrainIdentification='H' 
                  and bb.TrainSerial>0 
                  and bb.yesno=0