34,876
社区成员
发帖
与我相关
我的任务
分享求用一个表更新另一个表的SQL语句
table1 table2
id1 status id1 status
1 y 1 A
2 z 2 b
现在当table2.id1=table1.id1时,要用Table2的status的值代替table1中的status的值.
即更新后得到:
table1
id1 status
1 A
2 b
id1 status id1 status
1 y 1 A
2 z 2 b
现在当table2.id1=table1.id1时,要用Table2的status的值代替table1中的status的值.
即更新后得到:
table1
id1 status
1 A
2 b
...全文
请发表友善的回复…
发表回复
hqcsx 2004-10-13
- 打赏
- 举报
你可以试一下:
update table1 set table1.status=table2.status where table1.id=table2.id
update table1 set table1.status=table2.status where table1.id=table2.id
lsxaa 2004-10-13
- 打赏
- 举报
update table1 set status=table2.status
from table2
where table1.id1=table2.id1
from table2
where table1.id1=table2.id1
heibai520 2004-10-13
- 打赏
- 举报
update a set a.status=b.status
from table1 a,table2 b
where a.id1=b.id1
from table1 a,table2 b
where a.id1=b.id1
shuijun 2004-10-13
- 打赏
- 举报
update table1 set a.status = b.status
from table1 a inner join table2 b
on a.idl = b.idl
from table1 a inner join table2 b
on a.idl = b.idl
hsh_boy 2004-10-13
- 打赏
- 举报
upadte table1 set table1.status =table2.status
from table1,table2
where table1.idl=table2.idl
from table1,table2
where table1.idl=table2.idl
freddy2003 2004-10-13
- 打赏
- 举报
up
zjcxc 元老 2004-10-13
- 打赏
- 举报
update a set a.status=b.status
from table1 a,table2 b
where a.id1=b.id1
from table1 a,table2 b
where a.id1=b.id1
WangZWang 2004-10-13
- 打赏
- 举报
update a set a.status=b.status
from table1 as a
inner join table2 as b
on a.id1=b.id1
from table1 as a
inner join table2 as b
on a.id1=b.id1
