> -----Original Message----- > From: Markus Källander > [mailto:[EMAIL PROTECTED] > Sent: Wednesday, June 09, 2004 10:25 AM > To: [EMAIL PROTECTED] > 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 >
Sub-queries aren't supported in your version of MySQL. I believe you must have version >= 4.1 for that to work. -- Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]