Thomas Pundt wrote: > > On Freitag, 20. Juni 2008, Gregory Williamson wrote: <...snip...> > Does > > update foo > set foo.foo_name2 = foo_old.foo_name2 > from foo_old > where foo.foo_id = foo_old.foo_id; > > work for you?
Thanks to all for pointing out the FROM clause.! "UPDATE foo set foo_name2 = foo_old.foo_name2 FROM foo_old WHERE foo.foo_id = foo_old.foo_id;" did the trick. For some reason I keep forgetting that bit. Especially when under stress in the wee hours of the morn. Back to sleep ... ZZZzzzzZZZZ And thanks again ! GSW
