update sql syntax UPDATE operations covering multiple tables

[kanevd1]

I need a help with SQL syntax for UPDATE operations covering multiple
tables.
I tried following index:

update table1, table2 set table1.item_descr=table2.item_descr where
table1.item=table2.item.

It did not wprk form me.

Thanks.

[Dan Zeltner]

Yep, you can only update one table at a time. Split the command into two,
with one target table per update.

_________________________________________________________________
Get the latest Windows Live Messenger 8.1 Beta version. Join now.
http://ideas.live.com

[Fábio Pinheiro]

update table1 set table1.item_descr = table2.item_descr
from table1, table2 where table1.item = table2.item

try this....

Dan Zeltner escreveu:

[kanevd1]

Thank a lot, it has worked!!

On Nov 28, 12:34 pm, Fábio Pinheiro <fcpinhe...@gmail.com> wrote:
> update table1 set table1.item_descr = table2.item_descr
> from table1, table2 where table1.item = table2.item
>
> try this....
>
> Dan Zeltner escreveu:
>
> >Yep, you can only update one table at a time. Split the command into two,
> >with one target table per update.
>