insert into SupplementMaterialDetail(amount,price,sourceId,type) select amount,materialCost,id, '丢失明细' from RecyclingError; insert into SupplementMaterialDetail(amount,price,sourceId,type) select amount,materialCost,id, '报损明细' from RecyclingDamageItem; update SupplementMaterialDetail set price = 0 where price is null; update RecyclingError set materialCost = 0 where materialCost is null; update RecyclingDamageItem set materialCost = 0 where materialCost is null;