数据更新问题

[fashchina]

有一个表A
字段

ID Name age
1 张三 23

现在又建了一个表B

id address tel marrige name

1 dfd dfsd false 张三
他们之间的name是相同的

现在是B表里已经有数据了

现在我想在A表也新建
address tel marrige


那么怎么样把B表中对应的值插入到A表中呢

比如就想把B表中张三的信息对应的值和A表一样,差不多是B表已经不要,然后把它的值赋给A表对应的人的信息

SQL怎么写

[skyinfo]

UPDATE A SET A.address=B.address,A.tel=B.tel,A.marrige=B.marrige
FROM A
INNER JOIN B ON A.name=B.Name

[paoluo]

Update A set A.address=B.address,A.tel=B.tel,A.marrige=B.marrige From B Where A.name=B.name

[wtiancai]

update a set a.address=(select address from b where b.name=a.name),....
where a.name='张三'

[chinaandys]

select a.*,b.address,b.tel,b.marrige into #tmp
from 表A a left join 表B b -------------Left Join
on a.name=b.name
go
drop table 表A
go
sp_rename '#tmp','表A'

[xluzhong]

update 表a
set address=b.address,
tel=b.tel,
marrige=b.marrige
from 表a a
inner join 表b b
on a.name=b.name

[fashchina]

为什么mysql就不可以用呀?

[skyinfo]

在MySql中不要用INNER JOIN ,改為如下試試
UPDATE A SET A.address=B.address,A.tel=B.tel,A.marrige=B.marrige
FROM A,B WHERE A.name=B.name

[fashchina]

好象不行呀,怎么搞呀,