UPDATE VS4TPODelivery Set TPDEDate=(SELECT TPOBDeliveryDate FROM VS4TPOMB WHERE VS4TPOMB.TPOBTPODNo=VS4TPODelivery.TPDETPOBTPODNo AND VS4TPOMB.tpobln=VS4TPODelivery.TPDETPOBLn  )
GO
UPDATE VS4TPODelivery Set TPDEDateTime=(SELECT TPOBDeliveryTime FROM VS4TPOMB WHERE VS4TPOMB.TPOBTPODNo=VS4TPODelivery.TPDETPOBTPODNo AND VS4TPOMB.tpobln=VS4TPODelivery.TPDETPOBLn  )
GO