i am getting the error in the update query

Question

 update ao 
 set iansweroptionresultcount = 0 
 from tab_answeroption ao
 inner join tab_question q on q.pk_iquestion_id=ao.fk_iquestion_id
 where q.fk_iquestionaire_id=qid

Answer 1

You can't have "from" in an update. Or can you..* doubting himself *