Update a table by selecting data from another table MySQL ...

2011年2月22日 - First query to update based on status: UPDATE `order` o JOIN Order_Detail od ON o.or_id = od.order_id SET o.Status = 1 WHERE od.Status = 1.

stackoverflow.com