UPDATE VS4TQCsetMB SET TQCMName=(SELECT TQCCName FROM VS4TQC WHERE VS4TQCsetMB.TQCMTQCCCode=VS4TQC.TQCCCode) WHERE TQCMName='' OR TQCMName is null
GO
UPDATE VS4TQCsetMB SET TQCMName2=(SELECT TQCCName2 FROM VS4TQC WHERE VS4TQCsetMB.TQCMTQCCCode=VS4TQC.TQCCCode) WHERE TQCMName2='' OR TQCMName2 is null
GO
UPDATE VS4TQCsetMB SET TQCMStandard=(SELECT TQCCStandard FROM VS4TQC WHERE VS4TQCsetMB.TQCMTQCCCode=VS4TQC.TQCCCode) WHERE TQCMStandard='' OR TQCMStandard is null
GO
UPDATE VS4TQCsetMB SET TQCMEquipment=(SELECT TQCCEquipment FROM VS4TQC WHERE VS4TQCsetMB.TQCMTQCCCode=VS4TQC.TQCCCode) WHERE TQCMEquipment='' OR TQCMEquipment is null
GO
UPDATE VS4TQCsetMB SET TQCMMethod=(SELECT TQCCMethod FROM VS4TQC WHERE VS4TQCsetMB.TQCMTQCCCode=VS4TQC.TQCCCode) WHERE TQCMMethod='' OR TQCMMethod is null
GO
UPDATE VS4TQCsetMB SET TQCMMethodNote=(SELECT TQCCMethodNote FROM VS4TQC WHERE VS4TQCsetMB.TQCMTQCCCode=VS4TQC.TQCCCode) WHERE TQCMMethodNote='' OR TQCMMethodNote is null
GO
UPDATE VS4TQCsetMB SET TQCMStopEngine=(SELECT TQCCStopEngine FROM VS4TQC WHERE VS4TQCsetMB.TQCMTQCCCode=VS4TQC.TQCCCode) WHERE TQCMStopEngine='' OR TQCMStopEngine is null
GO
