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

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?

Stefan