UPDATE dbo.TR_REQUEST_DOC SET TOTAL_AMT=(SELECT  SUM(TOTAL_AMT_ETM) FROM dbo.TR_REQUEST_DOC_DT WHERE REQ_DOC_ID=REQ_ID) WHERE PL_REQ_ID ='PLRD00000200093'