Update with Embedded Select not working

[PeterMac]

What is wrong with this syntax ? Using MySQL 3.23.51-nt

UPDATE products SET manu_release_date = (SELECT dates.reldate FROM dates, products WHERE dates.id = products.stock_code )

I get the error:

Error MySQL said:

You have an error in your SQL syntax near 'SELECT dates.reldate FROM dates, products WHERE dates.id = products.stock_code )' at line 1

Any help appreciated...
Petermac

 

[sleipnir214]

I'm not sure MySQL supports UPDATE...SELECT.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[PeterMac]

well it supports insert... select so I just assumed... thanks...

Peter

 

[PeterMac]

Got this off the MySQL web pages...

Expanded support for subqueries
Subqueries allow you to use the result of one query as a component of a larger query. The MySQL server already supports some forms of this technique, such as INSERT INTO ... SELECT ..., and this support will be expanded in version 4.1 to include nested SELECT queries, which is one of the most-requested features from our users.

4.1 will have to be obtained and tested I guess...

Thanks for the reply
Petermac