Sub-select not supported in version you are using. -----Original Message----- From: Markus Källander To: [EMAIL PROTECTED] 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]