On Wed, 9 Jun 2004 18:25:11 +0200 Markus Källander <[EMAIL PROTECTED]> wrote:
> 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.
^^^^^^^
4.1 or higher is required for sub-selects.
http://dev.mysql.com/doc/mysql/en/Subqueries.html
Josh
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
