[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
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);
On Sun, Dec 27, 2009 at 01:46:22PM +0100, Sjoerd Mullender wrote:
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);
probably you want an extra
where anbikvk.naam in (select anbi_update.naam from anbi_update where anbi_update.naam = anbikvk.naam)
Niels
-- Sjoerd Mullender
This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
Op 27-12-09 13:46, Sjoerd Mullender schreef:
How doesn't it work? Do you get an error message, or doesn't it do what you expect?
On both of the efforts I get a cardinality error. Thinking a bit longer about that, maybe this is related to multiple results for some of the items.
Stefan
participants (3)
-
Niels Nes -
Sjoerd Mullender -
Stefan de Konink