UPDATE VS4TGLTrans SET TGLTCancelStatus=1,TGLTFlag2='71.159' WHERE TGLTNo in (select TCHSPassTGLTNo from VS4TChequeSub where TCHSChqStatus=4 AND TCHSPassTGLTNo is not null)
GO

UPDATE VS4TGLTrans SET TGLTCancelStatus=1,TGLTFlag2='71.159' WHERE TGLTNo in (select TCHRPassTGLTNo from VS4TChequeRec where TCHRChqStatus=4 AND TCHRPassTGLTNo is not null)
GO
