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 (

SELECT REQ_ID FROM dbo.TR_REQUEST_DOC WHERE REQ_ID iN


('TRRD00001055532',
'TRRD00001055533',
'TRRD00001055534',
'TRRD00001055535',
'TRRD00001055536',
'TRRD00001055537',
'TRRD00001055538',
'TRRD00001055539',
'TRRD00001055540',
'TRRD00001055541',
'TRRD00001055542',
'TRRD00001055543',
'TRRD00001055544',
'TRRD00001055545',
'TRRD00001055546',
'TRRD00001055547',
'TRRD00001055548',
'TRRD00001055549',
'TRRD00001055550',
'TRRD00001055551',
'TRRD00001055552',
'TRRD00001055553',
'TRRD00001055554',
'TRRD00001055555',
'TRRD00001055556',
'TRRD00001055557',
'TRRD00001055558',
'TRRD00001055559',
'TRRD00001055560',
'TRRD00001055561',
'TRRD00001055562',
'TRRD00001055563',
'TRRD00001055564',
'TRRD00001055565',
'TRRD00001055566',
'TRRD00001055567',
'TRRD00001055568',
'TRRD00001055569',
'TRRD00001055570',
'TRRD00001055571',
'TRRD00001055572',
'TRRD00001055573',
'TRRD00001055574',
'TRRD00001055575',
'TRRD00001055576',
'TRRD00001055577',
'TRRD00001055578',
'TRRD00001055579',
'TRRD00001055580',
'TRRD00001055581',
'TRRD00001055582',
'TRRD00001055583',
'TRRD00001055584',
'TRRD00001055585')
)