declare @a table(code varchar(100))insert @a
SELECT DISTINCT code
ROM t2
update t
set tag = 1
from t
inner join @a t3
on t.code = t3.code
SELECT DISTINCT code
ROM t2
update t
set tag = 1
from t
inner join @a t3
on t.code = t3.code
我已在SQL联机手册中找到了办法UPDATE t SET tag = 1 FROM t INNER JOIN t2 ON t.code = t2.code