i am completely agree with jeff. and manipulating the query as per him

UPDATE p

SET Part_Cost = I.Vendor_Cost

FROM PART p inner join Part_Supplier PS on p.partid=ps.partid

INNER JOIN Inventory I on I.Part_Id = PS.Part_Id