求助--该sql语句如何写? 我有两个表,table1和table2,table1的字段为(table1_Id,table1_name,cp1_id),table2的字段为(table2_Id,table2_name,cp2_id),要写的sql语句是,把表table1中的table1_name=table2_name的所有记录的cp1_id值都改成对应的cp2_id值。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 update table1 set cp1_id=cp2_idfrom table1,table2where table1_name=table2_name update t1set cp1_id=cp1_id2from table1 t1join table2 t2 on t1.table1_name=t2.table1_name2 UPDATE table1 SET table1.cp1_id = table2.cp2_idFROM table2WHERE table1.name = table2.name update table1 set cp1_id = (select cp2_id from table2 where table2_name=table1_name) update t1 set t1.cp1_id=t2.cp2_id from table1 t1 inner join table2 t2 on t1.table1_name=t2.table2_name UPDATE table1 SET table1.cp1_id = table2.cp2_idFROM table1,table2WHERE table1.name = table2.name; update table1 set cp1_id=b.cp2_id from table1 a,table2 b where a.table1_name=b.table2_name update table1 set cp1_id=b.cp2_id from table1 a,table2 b where a.table1_name=b.table2_name UPDATE table1 SET table1.cp1_id = table2.cp2_idFROM table1 join table2 on table1.name = table2.name update t1 set t1.cp1_id=t2.cp2_id from table1 t1 inner join table2 t2 on t1.table1_name=t2.table2_name update t1 set cp1_id=cp1_id2 from table1 t1 join table2 t2 on t1.table1_name=t2.table1_name2 -----建表table1-----create table table1(table1_Id int,table1_name varchar(16),cp1_id int)-----建表table2-----create table table2(table2_Id int,table2_name varchar(16),cp2_id int)-----table1插入数据-------insert into table1 (table1_Id,table1_name,cp1_id) values(1,'姚',1)-----table2插入数据-------insert into table2 (table2_Id,table2_name,cp2_id) values(1,'姚',2)--------修改update a set a.cp1_Id=b.cp2_Id from table1 a ,table2 b where a.table1_name=b.table2_name--------运行结果----table1 1,'姚',2table2 1,'姚',2 关于同时读写SQL Serve数据库的问题 求一个数据库设计问题! ***请教典型分类汇总问题??? sql 删除语句的机理探索 请教高手关于求和函数 哪有 microsoft sql server2000 下载? 存储过程里如何访问另一数据库服务器中的表? 寻求最简单的处理方法 sql2k 如何判断表中某列是否标识列(自动编号)及是否允许空? 如何在SQL SERVER2000中间处理不是一一对应的纪录 (给分) 修改字段 sqlserver,表中的一列,用于自动生成编号,怎么实现?
from table1,table2
where table1_name=table2_name
set cp1_id=cp1_id2
from
table1 t1
join
table2 t2 on t1.table1_name=t2.table1_name2
table1.cp1_id = table2.cp2_id
FROM table2
WHERE table1.name = table2.name
from table1 t1 inner join table2 t2
on t1.table1_name=t2.table2_name
table1.cp1_id = table2.cp2_id
FROM table1,table2
WHERE table1.name = table2.name;
update table1 set cp1_id=b.cp2_id from table1 a,table2 b where a.table1_name=b.table2_name
set cp1_id=b.cp2_id
from table1 a,table2 b
where a.table1_name=b.table2_name
table1.cp1_id = table2.cp2_id
FROM table1 join table2 on
table1.name = table2.name
from table1 t1 inner join table2 t2
on t1.table1_name=t2.table2_name
set cp1_id=cp1_id2
from
table1 t1
join
table2 t2 on t1.table1_name=t2.table1_name2
-----建表table1-----
create table table1(table1_Id int,table1_name varchar(16),cp1_id int)
-----建表table2-----
create table table2(table2_Id int,table2_name varchar(16),cp2_id int)
-----table1插入数据-------
insert into table1 (table1_Id,table1_name,cp1_id) values(1,'姚',1)
-----table2插入数据-------
insert into table2 (table2_Id,table2_name,cp2_id) values(1,'姚',2)--------修改
update a set a.cp1_Id=b.cp2_Id from table1 a ,table2 b where a.table1_name=b.table2_name--------运行结果----
table1 1,'姚',2
table2 1,'姚',2