update InventoryItem set sequence = (select sequence from DisposableGoods d where d.id = InventoryItem.diposableGoodsID) where diposableGoodsID is not null;