多表更新

UPDATE trade_order, apply_buy
SET trade_order.number_over = 0,
trade_order.traded_number = apply_buy.pass_count,
trade_order.traded_money = apply_buy.pass_count * apply_buy.sub_price
WHERE trade_order.outer_order_no = apply_buy.order_id