USE T25A001

UPDATE FIRM_ADDLESS_DETAIL set fldperc = t1.f1, fldamount = t1.f2 from (SELECT bktcsperc as f1, bktcsamt as f2, SRNO as f3 FROM GREY_PURCHASE WHERE BKTCSAMT<>0) as t1 WHERE FORMNAME = 'GREY PURCHASE' AND FLDNAME = 'TCS' and formsrno = t1.f3