Re: [MonetDB-users] Updating a single column by means of a secondary table

On 2009-12-27 12:49, Stefan de Konink wrote:

Hi,

I have the following issue; I would like to update a new column with respect to old data.

In essence this would be the idea that I want to do:

update anbikvk set intrekking = (select intrekking from anbi_update where anbi_update.naam = anbikvk.naam);

The above way does not work, the only other way that I would know would involve a temporary table. Could anyone elaborate how this is possible using the update statement?

How doesn't it work? Do you get an error message, or doesn't it do what you expect?

Does this work:

update anbikvk set intrekking = (select anbi_update.intrekking from anbi_update where anbi_update.naam = anbikvk.naam);