Update inner join

#31

Quote:

I'm not 100% sure if that's what you want, but maybe you are looking
for something like the following:

UPDATE t1 SET t1.col1 = t2.col2 FROM t2 WHERE t1.fkey = t2.pkey;

Precisely what I sought thanks

#32

Quote:

I'm not 100% sure if that's what you want, but maybe you are looking
for something like the following:

UPDATE t1 SET t1.col1 = t2.col2 FROM t2 WHERE t1.fkey = t2.pkey;

Precisely what I sought thanks

#33

Quote:

I'm not 100% sure if that's what you want, but maybe you are looking
for something like the following:

UPDATE t1 SET t1.col1 = t2.col2 FROM t2 WHERE t1.fkey = t2.pkey;

Precisely what I sought thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Update inner join

comp.databases.postgresql comp.databases.postgresql

Re: Update inner join - 03-20-2008 , 05:42 AM

Re: Update inner join - 03-20-2008 , 05:42 AM

Re: Update inner join - 03-20-2008 , 05:42 AM