UPDATE VS4TSODelivery Set TMDSDate=(SELECT TSOBUseDate FROM VS4TSOMB WHERE VS4TSOMB.TSOBTSODNo=VS4TSODelivery.TMDSTSOBTSODNo AND VS4TSOMB.TSObln=VS4TSODelivery.TMDSTSOBLn)
GO
UPDATE VS4TSODelivery Set TMDSDateTime=(SELECT TSOBUseDate FROM VS4TSOMB WHERE VS4TSOMB.TSOBTSODNo=VS4TSODelivery.TMDSTSOBTSODNo AND VS4TSOMB.TSObln=VS4TSODelivery.TMDSTSOBLn)
GO