Need help with "update query"

[hoctro]

I have this sample problem where I want to update table test1 if the id in both tables match.


Problem (sample data):
========
Table "Test1"

id name
-- -------
1 "rrr"
2 "ttt"
4 "sss"

Table "Test 2"

id name
-- -------
1 "fff"
2 "ggg"
3 "hhh"

Expected Results:
Results:
Test1:

id name
-- ------
1 "fff"
2 "ggg"
4 "sss"



This query doesnt work. What is wrong with it ?
update Test1
set Test1.name = Test2.name
from Test1, Test2
where Test1.id = Test2.id


Much thanks,
Nga

 

[chidi]

Your query won't work because you are using a "from statement" in an update statement improperly.
Try this:

update Test1
set Test1.name = (select Test2.name
from Test2
where Test1.id = Test2.id)
This should work. Let me know. Hope this response didn't come too late.
chidi

 

[hoctro]

You are right!!!
Thanks, Chidi