mysql从另一个表取字段更新当前表

表1：ph_out_in_apply，表 2：ph_out_in_record ，

从表2取字段更新表1的字段，关联字段是order_no

注意：不能用别名

update ph_out_in_apply,ph_out_in_record 
 set ph_out_in_apply.supplier_name = ph_out_in_record.supplier_name,
     ph_out_in_apply.operator = ph_out_in_record.operator,
     ph_out_in_apply.operate_time = ph_out_in_record.operate_time 
where ph_out_in_apply.order_no = ph_out_in_record.order_no;

进阶：四个表

update ph_out_in_apply_detail,ph_out_in_record,ph_out_in_record_detail,ph_out_in_apply
   set ph_out_in_apply_detail.rate=ph_out_in_record_detail.rate
where ph_out_in_apply.order_no=ph_out_in_record.order_no and ph_out_in_apply_detail.apply_id=ph_out_in_apply.id and ph_out_in_record.record_no = ph_out_in_record_detail.record_no and ph_out_in_apply_detail.inventory_code = ph_out_in_record_detail.inventory_code