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
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