hi
what jovery says is true u r inner select statment is returning more than one row in any updates. first make sure that u r inner select statment is returning single row. or u can use "in" clause insted of where clause in u r update statment.

good luck.