mysql query not working

[phparion]

hi

i am running this query

update utest set utest_score = (select count from uanswer, answer where uanswer_utest_id = 24 and uanswer_answer_id = answer_id and answer_correct = 1 ) where utest_id = 24  

both queries work seperately but it is not working in this pattern, what could be wrong?

[txbakers]

it could be your version of mySQL.

Nested updates were only recently added. See the mySQL website for more information on it.