高分求一个简单的UPDATE语句 2个表,a 和 ba 和 b中有一个相同的字段IDa中有个USERNAME ,b中有个name 我想根据ID号,将a的username替换成b的name字段 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 UPDATE a SET a.username=b.nameFROM bWHERE a.id=b.id UPDATE a SET a.username=b.name FROM ta a inner join tb bon a.id=b.id update a set username=name from a inner join b on a.id=b.id UPDATE a SET a.username=b.name FROM ta a INNER JOIN tb b ON a.id=b.id select a.其他列,b.namefrom a join bon a.id=b.id UPDATE ASET username =B.nameFROM A,BWHERE A. ID = B.ID SQL codeUPDATE a SET a.username=b.name FROM ta a INNER JOIN tb b ON a.id=b.id[/Quote] update aset a.username=b.namefrom ainner join b on a.id=b.id UPDATE a SET a.username=b.name FROM b WHERE a.id=b.id update aset a.username=b.namefrom ainner join b on a.id=b.id UPDATE a SET a.username=b.name FROM b WHERE a.id=b.id 求分类汇总............... 怎么用sql语句去掉指定表的只读属性 救急!!!如何修改 @@servicename ?? 高分请教存储图片到数据库的问题 问一个很菜的问题,关系有什么用处?最好详细一些.. Sql数据库更新问题 请高手看下我这一句sql有没错误? 执行大批量查询吃掉所有内存然后抱Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e21',大家有相似经历吗 ???? 请给入门者一个帮助,一个SQL语句的问题??? 有关SQL更改密码的问题。 ?sql 这个截图是什么软件
SET a.username=b.name
FROM b
WHERE a.id=b.id
SET a.username=b.name
FROM ta a inner join tb b
on a.id=b.id
update a set username=name from a inner join b on a.id=b.id
SET a.username=b.name
FROM ta a
INNER JOIN tb b ON a.id=b.id
from a join b
on a.id=b.id
FROM A,B
WHERE A. ID = B.ID
SET a.username=b.name
FROM ta a
INNER JOIN tb b ON a.id=b.id
[/Quote]
set a.username=b.name
from a
inner join b on a.id=b.id
SET a.username=b.name
FROM b
WHERE a.id=b.id
set a.username=b.name
from a
inner join b on a.id=b.id
SET a.username=b.name
FROM b
WHERE a.id=b.id