UPDATE PL_TRADEDETAIL SET AMT_ETM =89000000 WHERE TRADE_ID ='PLT000000278913' DECLARE @REQ_ID VARCHAR(15) SET @REQ_ID =(SELECT REQ_PAY_ID FROM TR_REQ_PAYMENT WHERE REQ_PAY_CODE ='082021/000315') SELECT * FROM TR_REQ_PAY_METHOD WHERE REQ_PAY_ID=@REQ_ID UPDATE TR_REQ_PAY_METHOD SET ACC_NO ='0017041044843', ACC_NAME='Công ty TNHH Phần mềm Hoàn Cầu', ISSUED_BY ='BVB-CN Tây Sài Gòn' WHERE REQ_PAY_ID =@REQ_ID SELECT * FROM CM_SUPPLIER UPDATE CM_SUPPLIER SET MAKER_ID ='tuyenlt' WHERE SUP_ID ='CMS000000251971'