List:General Discussion« Previous MessageNext Message »
From:Jørn Dahl-Stamnes Date:April 26 2007 3:31pm
Subject:Re: Update question
View as plain text  
On Wednesday 25 April 2007 23:14, you wrote:
> try this:
>
>
> update table1, table2
> set table1.value = table2.value
> where table1.id = table2.id

Thanks for the replies... It was late evening when I tried to figure out how 
to do this.

Today I found the answer myself, which is exactly as described above.

Lesson learned: Get a good night sleep and then try to figure out how to do 
things... ;-)

-- 
Jørn Dahl-Stamnes
homepage: http://www.dahl-stamnes.net/dahls/
Thread
Update questionJørn Dahl-Stamnes25 Apr
  • Re: Update questionMogens Melander25 Apr
Re: Update questionJørn Dahl-Stamnes26 Apr