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