update select?

[adunphy]

can you do something like this?

I have two tables
a and b
a has a new column id which I want to retrieve from b

update a set id = (select b.id from b where b.name = a.name) ?

a (name, id) = id just added and is currently null..needs to be updated to what is shown in b... ?
b (name, id)

[Lars_Berg]

Yes, your statement is valid SQL.

[adunphy]

i get an error...
UPDATE adunphy_Dog SET vid = ( SELECT adunphy_vet.vid
FROM adunphy_vet
WHERE name = vet )

[nemonoman]

If using mysql you can't update using a select.