UPDATE VS4TQCMB SET TQDMName=(SELECT TQCCName FROM VS4TQC WHERE VS4TQCMB.TQDMTQCCCode=VS4TQC.TQCCCode) WHERE TQDMName='' OR TQDMName is null
GO
UPDATE VS4TQCMB SET TQDMName2=(SELECT TQCCName2 FROM VS4TQC WHERE VS4TQCMB.TQDMTQCCCode=VS4TQC.TQCCCode) WHERE TQDMName2='' OR TQDMName2 is null
GO
UPDATE VS4TQCMB SET TQDMStandard=(SELECT TQCCStandard FROM VS4TQC WHERE VS4TQCMB.TQDMTQCCCode=VS4TQC.TQCCCode) WHERE TQDMStandard='' OR TQDMStandard is null
GO
UPDATE VS4TQCMB SET TQDMEquipment=(SELECT TQCCEquipment FROM VS4TQC WHERE VS4TQCMB.TQDMTQCCCode=VS4TQC.TQCCCode) WHERE TQDMEquipment='' OR TQDMEquipment is null
GO
UPDATE VS4TQCMB SET TQDMMethod=(SELECT TQCCMethod FROM VS4TQC WHERE VS4TQCMB.TQDMTQCCCode=VS4TQC.TQCCCode) WHERE TQDMMethod='' OR TQDMMethod is null
GO
UPDATE VS4TQCMB SET TQDMMethodNote=(SELECT TQCCMethodNote FROM VS4TQC WHERE VS4TQCMB.TQDMTQCCCode=VS4TQC.TQCCCode) WHERE TQDMMethodNote='' OR TQDMMethodNote is null
GO
UPDATE VS4TQCMB SET TQDMStopEngine=(SELECT TQCCStopEngine FROM VS4TQC WHERE VS4TQCMB.TQDMTQCCCode=VS4TQC.TQCCCode) WHERE TQDMStopEngine='' OR TQDMStopEngine is null
GO
