update 表1
set a = ‘2’
where x = (select x from 表1 join 表2 on 表1.x=表2.x where 表2.y = ‘3’ )
update 表1 set a=2 where 表1 inner join 表2 on 表1.x=表2.x and y=3
update table1
set a = 2
from table1 join table2 on table1.x=talbe2.x and table2.y = 3
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024