I need a small help on a query

[webdev]

hello, My query is not working the way i want. I am trying to do this: if work_done is "Yes" for all the item_id then SET order_ready to "Yes" if work_done is "No" for 1 item_id then SET order_ready to "No" the problem is on second query. If there is 1 item, my query works. it sets to...