UPDATE ProductMixes SET DesignProductRelationUniqueID = DesignProductRelation.QestUniqueID
  FROM ProductMixes LEFT OUTER JOIN DesignProductRelation ON ProductMixes.Plant=DesignProductRelation.PlantCode AND ProductMixes.ProductCode = DesignProductRelation.ProductCodeWithAlternative 
  WHERE ProductMixes.DesignProductRelationUniqueID IS NULL
GO

UPDATE ProductMaterialWeights SET DesignProductRelationUniqueID = DesignProductRelation.QestUniqueID 
  FROM ProductMaterialWeights LEFT OUTER JOIN DesignProductRelation ON ProductMaterialWeights.PlantCode=DesignProductRelation.PlantCode AND ProductMaterialWeights.ProductCode = DesignProductRelation.ProductCodeWithAlternative 
  WHERE ProductMaterialWeights.DesignProductRelationUniqueID IS NULL
GO

UPDATE ProductMixes SET DesignProductRelationUniqueID = 0 WHERE DesignProductRelationUniqueID IS NULL
UPDATE ProductMaterialWeights SET DesignProductRelationUniqueID = 0 WHERE DesignProductRelationUniqueID IS NULL
GO