update friend_help SET thought = (select choice.choice_name FROM choice WHERE choice.iscorrect = '1' AND choice.question_id = friend_help.question_id)
WHERE friend_help.thought like '%這個題目類別%' AND (select question.category_id FROM question WHERE question.question_id = friend_help.question_id)<10
沒有留言:
張貼留言