UPDATE VS4TJobProductionM Set TJPMSelfMaterial=(SELECT top 1 TSpdSelfMaterial FROM VS4TProductMethod WHERE VS4TProductMethod.TSpdTSepCode=VS4TJobProductionM.TJPMTSepCode AND  VS4TProductMethod.TSpdTPdtCode=VS4TJobProductionM.TJPMTPdtCode)
GO
UPDATE VS4TJobMethod Set TJsTSelfMaterial=(SELECT TOP 1 TSpdSelfMaterial FROM VS4TProductMethod WHERE VS4TProductMethod.TSpdTSepCode=VS4TJobMethod.TJStTSepCode AND VS4TProductMethod.TSpdTPdtCode=VS4TJobMethod.TJStTPdtCode)
GO
