UPDATE VS4TCertificate SET TCerRefDate=TCerDate
UPDATE VS4TCertificate SET TCerTARNCode=(select top 1 tptatarncode from vs4tpostrans where tptano=tcerrefno)
UPDATE VS4TCertificate SET TCerTBRACode=(select top 1 tptatbracode from vs4tpostrans where tptano=tcerrefno)
UPDATE VS4TCertificatesub SET TCeMNetPrice=(select top 1 tptsnetamount from vs4tpostranssub where tcemtcerno=tcerrefno and tcemln=tptsln)