update table2
set field2=1
from table1,table2
where table1.field1=table2.field1
and table1.field2=1
set field2=1
from table1,table2
where table1.field1=table2.field1
and table1.field2=1
调试欢乐多
From table2 INNER JOIN table1 ON table2.field1=table1.field1 AND table1.field2=1
set b.field2=a.field2
from table1 a,table2 b
where a.field1=a.field1
and a.field2=1
update b
set b.field2=a.field2
from table1 a,table2 b
where a.field1=b.field1
and a.field2=1