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

[Laercio Xisto Braga Cavalcanti]

Hi Markus,

You cannot use sub-query in mysql 3.23.49

Regards,

Laercio Cavalcanti. 

-----Original Message-----
From: Markus Källander [mailto:markus.kallander@stripped] 
Sent: quarta-feira, 9 de junho de 2004 13:25
To: mysql@stripped
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