create table t1 ( key1 int, x int) create table t2 (key2 int, y int) insert into t1 values(1,2) insert into t1 values(3,5) insert into t1 values(3,7) go insert into t2 select 1,4 insert into t2 select 3,222 insert into t2 select 4,123go update t1 set x =(select y from t2 where t1.key1=t2.key2) select * from t1 结果: 1 4 3 222 3 222 正确
( key1 int,
x int)
create table t2
(key2 int,
y int)
insert into t1 values(1,2)
insert into t1 values(3,5)
insert into t1 values(3,7)
go
insert into t2 select 1,4
insert into t2 select 3,222
insert into t2 select 4,123go
update t1 set x =(select y from t2 where t1.key1=t2.key2)
select * from t1
结果:
1 4
3 222
3 222
正确