SELECT * FROM TR_REQUEST_DOC WHERE REQ_ID IN ('TRRD00000253160','TRRD00000252757') SELECT * FROM TR_REQUEST_DOC_DT WHERE REQ_DOC_ID IN ('TRRD00000253160','TRRD00000252757') SELECT * FROM PL_REQUEST_DOC_DT WHERE REQDT_ID IN (SELECT PL_REQDT_ID FROM TR_REQUEST_DOC_DT WHERE REQ_DOC_ID IN ('TRRD00000253160','TRRD00000252757')) ---2021816