Update with two tables??

I am trying to update table A with data from table B. I thought I could do
something like:

UPDATE A
SET A.name = B.name
WHERE A.id = B.id
FROM B

but alas, this does not work.

Anyone have an idea of how I can do this?

-Mark

-----------------------------------------------------------------
Mark Lundquist
mlundquist(at)bvsdps(dot)com
-----------------------------------------------------------------