Update VS4TTeasuryTrans set TTETDate =(select tdpsdate from VS4TCashDeposit Where TTETRefNo=TDPSNo) where TTeTType=1

Update VS4TTeasuryTransMB set TTTMValidDate =(select ttetdate from VS4TTeasuryTrans Where TTTMTTeTNo=TTeTNo)

Update VS4TTeasuryTransMB set TTTMValidDate =(select TCHRCashDate from VS4TChequeRec Where TTTMChequeNo=TCHRNo) WHERE (TTTMChequeNo<>'' or TTTMChequeNo is not Null)

Update VS4TTeasuryTransMB set TTTMChequeStatus =(select TCHRChqStatus from VS4TChequeRec Where TTTMChequeNo=TCHRNo) WHERE (TTTMChequeNo<>'' or TTTMChequeNo is not Null)

Update VS4TTeasuryTransMB set TTTMValidDate =(select ttetdate from VS4TTeasuryTrans Where TTTMTTeTNo=TTeTNo) where TTTMValidDate='8/8/8888'