Re: [SQL] SQL - update table problem...

2006-11-14 Thread Bruno Wolff III
On Mon, Nov 13, 2006 at 11:36:05 +0100, Marko Rihtar <[EMAIL PROTECTED]> wrote: > > i'm trying to do update on multiple tables but don't know how. > is something like this posible with postgresql? I believe you need to use multiple update statements to do this. Each update can only update one t

[SQL] SQL - update table problem...

2006-11-13 Thread Marko Rihtar
Hi, first i'm sorry if this message appears twice. first time didn't get through because i wasn't registered. i'm trying to do update on multiple tables but don't know how. is something like this posible with postgresql? update table1 join table2 on (table1.id=table2.t1) join table3 on (table