[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