RE: UPDATE...WHERE ... IN (SELECT...)

[Victor Pendleton]

Sub-select not supported in version you are using. 

-----Original Message-----
From: Markus Källander
To: mysql@stripped
Sent: 6/9/04 11:25 AM
Subject: UPDATE...WHERE ... IN (SELECT...)

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