Re: [SQL] Update with two tables??

On Wed, 16 Jun 1999, Mark wrote:

> 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?

It works. But you don't need A.name:
UPDATE A
SET name = B.name
FROM B
WHERE A.id = B.id;

@------------------+-----------------------------------------------@
| Fomichev Mikhail | The Government of Kamchatka region. |
| Vladimirovich | The Labour and Social Development Department. |
|<fomichev(at)null(dot)ru>| |
@------------------+-----------------------------------------------@