更新移动库存表(warehouse_inventoryrecords)的code_
移动库存表关联出库明细表(warehouse_outbounditems)
code_ 来自出库表(warehouse_outbounds)
update warehouse_inventoryrecords as wi
set code_ = a.code_from (select woi.id_, wo.code_ from warehouse_outbounditems as woi
inner join warehouse_outbounds as wo on woi.outboundid_ = wo.id_) as a
where wi.type_ = 'OUT' and wi.inandoutanddeliveryid_ = a.id_