views:

41

answers:

0

Here is what i have:

UPDATE webdev.tempdb.dbo.MediaResource
   SET Date_Min_Enabled = PRAH.DateCreated
  FROM FeedBack.dbo.Part_Resource_Associations_History as PRAH
  JOIN WebDev.DataWareHouse.dbo.Inventory as I on I.SKU = PRAH.PartNumber
  JOIN FeedBack.dbo.Part_Resource_Associations as PRA on PRA.PartNumber = I.SKU

This only returns one date for every sku