UPDATE dbo.PL_REQUEST_PROCESS_CHILD SET PROCESS_ID=(SELECT ID FROM dbo.PL_REQUEST_PROCESS WHERE PL_REQUEST_PROCESS_CHILD.REQ_ID=PL_REQUEST_PROCESS.REQ_ID AND PROCESS_ID='DMMS') WHERE PL_REQUEST_PROCESS_CHILD.REQ_ID IN ('TRRDI001055340', 'TRRDI001055341', 'TRRDI001055342', 'TRRDI001055343')