UPDATE...WHERE ... IN (SELECT...)

[Markus Källander]

Hi all,
 
Can someone tell me what is wrong with this statement? 
 
UPDATE nummer SET gold = '1' WHERE anr IN (SELECT no FROM gull);
 
I use MySQL 3.23.49.
 
Thanks
Markus Källander