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
