问使用内部连接更新多个表

EN

UPDATE pur_order a, pur_entry b SET a.is_deleted = 1, b.is_deleted = 1
WHERE b.id_pur_order = b.id AND a.id = 1;

UPDATE Pur_order, Pur_entry
   SET Pur_order.is_deleted = 1
      ,Pur_entry.is_deleted = 1
 WHERE Pur_entry.id_pur_order = Pur_order.id
   AND Pur_order.id = @YourDesiredUpdateId
;