子查询返回多个值，如何执行UPDATE呢？

[雪月天霜]

update ST_person set is_del ='1' where person_id=(select person_id from ST_card where Card_ValidDate<getdate())

因为子查询的person_id是会有多个结果的，那我怎么样才能将 where person_id=子查询结果，这样全部update一遍呢？求指导。。我是初学者。

[AcHerat]

update a 
set is_del ='1' 
from ST_person a join ST_card b on a.person_id = b.person_id
where b.Card_ValidDate<getdate()

[黄_瓜]

update ST_person set is_del ='1' where person_id in (select person_id from ST_card where Card_ValidDate<getdate())

[百年树人]

update a set a.is_del ='1' 
from ST_person a,ST_card b
where a.person_id=b.person_id 
and b.Card_ValidDate<getdate()

[Shawn]

;with cte as
(
	select
		a.is_del
	from ST_person a
		inner join ST_card b
			on a.person_id = b.person_id
				and b.Card_ValidDate < getdate()
)
update cte
set is_del = '1'