subqueries with UPDATE statement

[yuda_zdk]

OS: red hat 9
PHP version: 4.2.2
MySQl version: 3.23.58

I'm trying to do update statement with subquery and it fails:
The subquery is:
"UPDATE product,product_aas SET product_aas.quantity=product.tot_quantity
WHERE product_aas.product_id=product.product_id"

I get a syntax error doing it.
What other option do I have ?

Thanks

[devinemke]

mySQL 3.23.58 does not support subqueries. either use multiple queries or upgrade to mySQL 4.1.x