update a1 set id=b.id from a1 a left join a2 b on a.id=b.id
update A1 set id=A2.id from A1 join A2 on A1.name=A2.name
UPDATE A1 SET A1.ID=A2.ID FROM A1, A2 WHERE A1.name=A2.name
我有两个表, A1,A2 A1中有字段name,id A2中有字段name,id 我需要在A1的name等于A2的name时,A1的id等于A2的id 请问这个语句怎么写啊 等着用啊,谢谢大家了!update A1 set id = A2.id from A1,A2 where A1.name = A2.name
update a1 set id=b.id from a1 a left join a2 b on a.id=b.id
set id=A2.id
from A1 join A2 on A1.name=A2.name
FROM A1, A2
WHERE A1.name=A2.name
A1,A2
A1中有字段name,id
A2中有字段name,id
我需要在A1的name等于A2的name时,A1的id等于A2的id
请问这个语句怎么写啊
等着用啊,谢谢大家了!update A1
set id = A2.id
from A1,A2
where A1.name = A2.name