菜鸟求助SQL语句！

[new_one_one]

跨表更新：
A表：id，name
B表：id，number，name

实现目标：按照两表name相同的字段，把A表的id字段值更新到B表的number字段。
我的SQL语句：
update B set number=A.id from A where rtrim(A.name)=rtrim(B.name)
在TOAD下运行错误，提示：ORA-00933: SQL command not properly ended

求达人指正！！！

不胜感激！！！

[jiao3630]

貌似么啥错误
下班回家了

[ForFumm]

UDPATE B SET number=A.id FROM A, B WHERE RTRIM(A.name)=RTRIM(B.name)

[快溜]

update B set B.number=A.id from B,A where rtrim(A.name)=rtrim(B.name)

[new_one_one]

错误依旧
[Quote=引用 2 楼 forfumm 的回复:]
SQL code
UDPATE B SET number=A.id FROM A, B WHERE RTRIM(A.name)=RTRIM(B.name)
[/Quote]

[new_one_one]

还是提示错误：ORA-00933: SQL command not properly ended
呢
提示错误在 from 处

[Quote=引用 3 楼 ssp2009 的回复:]
update B set B.number=A.id from B,A where rtrim(A.name)=rtrim(B.name)
[/Quote]

[qgqch2008]

update set B.number = A.id from A join B on rtrim(A.name)=rtrim(B.name)

[new_one_one]

不得行啊 不得行

[Billy]

update B set number=(select id from a where rtrim(A.name)=rtrim(B.name)) where exist
(
select 1 from a where rtrim(A.name)=rtrim(B.name)) 
)

貌似oracle环境下，mssql环境下UPDATE没问题的
转版

[水向东流时光怎么偷]

[Quote=引用 8 楼 xyctc 的回复:]
SQL code
update B set number=(select id from a where rtrim(A.name)=rtrim(B.name)) where exist
(
select 1 from a where rtrim(A.name)=rtrim(B.name))
)

貌似oracle环境下，mssql环境下UPDATE没问题的
转版
[/Quote]


他是oracle,不是SQL,語法上有點區別,你到oracle版問問吧
他是

[So_CooL]

update c
set b.number = c.id from A c inner join B on c.name  = b.name