摘要： update TableA as a inner join TableB as b on a.order_id=b.order_id set a.last_time='2018-01-01' where b.channel_ordersn='18'; 阅读全文